Re: [sqlite] What is the best way to store date value in sqlite

2005-02-21 Thread Jay
Ah, sorry, didn't know about the ole version. I'll have to check to see if they implemented that in Excel etc. I had a lot of trouble with it under Access and Excel --- "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > HI Jay, > > CTime::GetTime() return time_t which is long integer. > > Ming

RE: [sqlite] What is the best way to store date value in sqlite

2005-02-21 Thread Dennis Volodomanov
se GetYear(), GetMonth(), GetDay(), GetHour(), GetMinute(), GetSecond() functions - that's true. Dennis -Original Message- From: Jay [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 22, 2005 12:55 PM To: sqlite-users@sqlite.org; [EMAIL PROTECTED] Subject: Re: [sqlite] What is the best way to

Re: [sqlite] What is the best way to store date value in sqlite

2005-02-21 Thread [EMAIL PROTECTED]
HI Jay, CTime::GetTime() return time_t which is long integer. Ming Jay wrote: The MFC date is stored as a floating point number, the unix date as a long integer. The MFC style date, used through out windows has a maximum date of somewhere around 2038AD. The unix variant goes several thousand years

Re: [sqlite] What is the best way to store date value in sqlite

2005-02-21 Thread Jay
The MFC date is stored as a floating point number, the unix date as a long integer. The MFC style date, used through out windows has a maximum date of somewhere around 2038AD. The unix variant goes several thousand years farther. You could certainly store the float date as a float type field but

Re: [sqlite] What is the best way to store date value in sqlite

2005-02-21 Thread Jay
--- "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > Anyway get get Unix Epoch Time in Windows MFC, or win32? Yes, the same way you do in unix. long ago; time( & ago ); = - "Lord Tarlington gazed upon the crazed Egyptian hieroglyphics on the walls of

Re: [sqlite] What is the best way to store date value in sqlite

2005-02-21 Thread Uriel_Carrasquilla
; > > "[EMAIL PROTECTED] > co.ca" cc: > 02/21/2005 05:29 Subject: [sqlite] What is the best way to store date value in sqlite > PM > Pl

Re: [sqlite] What is the best way to store date value in sqlite

2005-02-21 Thread [EMAIL PROTECTED]
Anyway get get Unix Epoch Time in Windows MFC, or win32? [EMAIL PROTECTED] wrote: Ming: I asked the same question about two weeks ago to this same list. I was directed to the following location: http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions I ended up saving my date/time in Unix

[sqlite] What is the best way to store date value in sqlite

2005-02-21 Thread [EMAIL PROTECTED]
Hi All, I want to store MFC date (CTime or COleDateTime) value in sqlite, but don't know what is the best way to store it. I am running into trouble when I store date as Text in sqlite, because I can't no longer apply sqlite date time functions( datetime(), date()...) to it. Result in I can't