[sqlite] how to store date/time in sqlite?

[Mark Wyszomierski]

 Hi all,
 Moving from a mysql database to sqlite. I had some date/time fields in my 
mysql database. I would just populate them using the now() function. How 
could I achieve the same in my new sqlite database?
 Thanks!
Mark