Re: [sqlite] How to decode a date

2008-03-18 Thread Dennis Cote
[EMAIL PROTECTED] wrote:
> 
> I would like to know how to decode a Date when I read a table.  The same
> question for Time.
> 

See http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions for details.

HTH
Dennis Cote
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] How to decode a date

2008-03-18 Thread Scott Baker
[EMAIL PROTECTED] wrote:
> Hello,
> 
> I would like to know how to decode a Date when I read a table.  The same
> question for Time.

The wiki on this question is quite good (and not just because I 
editted some of it).

http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions

-- 
Scott Baker - Canby Telcom
RHCE - System Administrator - 503.266.8253
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] How to decode a date, I found the answer !

2008-03-18 Thread Michel . Rodrigue
>  -Message d'origine-
> De :  Rodrigue, Michel (TIT-SA)  
> Envoyé :  2008-03-18 14:49
> À :   'sqlite-users@sqlite.org'
> Objet :   How to decode a date
> 
> Hello,
> 
> I would like to know how to decode a Date when I read a table.  The same
> question for Time.
> 
> Thank you very much.
> __ 
> Michel Rodrigue, B.Sc.A. 
> Conseiller en systèmes d'information
> Ville de Québec 
> 
> 
> 
> 
> 
> 
> 
> 
> I have found the answer at
> http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions
> 
> Thank you very much
> 
> Michel Rodrigue
> 
> 
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


[sqlite] How to decode a date

2008-03-18 Thread Michel . Rodrigue
Hello,

I would like to know how to decode a Date when I read a table.  The same
question for Time.

Thank you very much.
__ 
Michel Rodrigue, B.Sc.A. 
Conseiller en systèmes d'information
Ville de Québec 

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users