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?
Thanks,
Vania
--
Vania Smrkovski
http://www.pandorasdream.com
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
