Hello, Tried to find a reference to this on the wiki and FAQ. Sorry if I missed it. I'm looking to implement a datetime stamp for a series of tables I am creating. I have a need to automatically keep track of creation dates and modification dates for my data rows.
I need only use a trigger that automatically populates these fields on creating a record, but (and maybe it's the SQLite manager program I am using), I haven't been able to use date(), the SQL function that is available in some implementations of SQL.
The functions list on sqlite.org lists such functions as min(), max(),
and so forth. But not date().
Is there one available? I see a date.c in the source code files, but cannot stumble upon the syntax to populate the current date.
Can someone guide me?
http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions
You probably want: datetime('now')
The value returned is UTC, not local time.
-- D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
