Re: [sqlite] Using time and date values

"Henning Folger" <[EMAIL PROTECTED]> wrote: > > I am looking for a simple way of using date and time values with > sqlite3. http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions -- D. Richard Hipp <[EMAIL PROTECTED]>

Re: [sqlite] Using time and date values

Brad wrote: I am looking for a simple way of using date and time values with sqlite3. I have some Ctime classes (VC++.net) which have to be stored in the database and they should be compared. If the class you're using has .Value property, or a way to easily transform the date from one

Re: [sqlite] Using time and date values

hi maybe the GMT is obsolete. The new time-standart becomes BMT - Biel Mean Time, which is linked up to the Central European Winter/Standard time - which is UTC + 1 hour (aka internet time). regards e. Цитат на писмо от John Stanton <[EMAIL PROTECTED]>: > Brad wrote: > >> I am looking for a

Re: [sqlite] Using time and date values

Dennis Cote wrote: John Stanton wrote: Brad wrote: I am looking for a simple way of using date and time values with sqlite3. I have some Ctime classes (VC++.net) which have to be stored in the database and they should be compared. If the class you're using has .Value property, or a

Re: [sqlite] Using time and date values

John Stanton wrote: Brad wrote: I am looking for a simple way of using date and time values with sqlite3. I have some Ctime classes (VC++.net) which have to be stored in the database and they should be compared. If the class you're using has .Value property, or a way to easily

Re: [sqlite] Using time and date values

Brad wrote: I am looking for a simple way of using date and time values with sqlite3. I have some Ctime classes (VC++.net) which have to be stored in the database and they should be compared. If the class you're using has .Value property, or a way to easily transform the date from one format

Re: [sqlite] Using time and date values

I am looking for a simple way of using date and time values with sqlite3. I have some Ctime classes (VC++.net) which have to be stored in the database and they should be compared. If the class you're using has .Value property, or a way to easily transform the date from one format to another,

Re: [sqlite] Using time and date values

Hello Henning, CTime will give you access to the "time_t" field. I just store the time_t in the DB. It's an unsigned long that represents seconds since Jan 1, 1970. You can feed a time_t back into CTime to initialize it. Be aware though that Microsoft is changing what "time(NULL)" returns. I

[sqlite] Using time and date values

Hi, I am looking for a simple way of using date and time values with sqlite3. I have some Ctime classes (VC++.net) which have to be stored in the database and they should be compared. Anyone has an idea? Henning