how do I insert this date format : '19:52:10 Aug 02, 2005 PDT'

[briforge]

I'm receiving a date in the format '19:52:10 Aug 02, 2005 PDT', which I would like to insert - how do I do this? It looks like none of the date/time types are in this format. Is there a function to convert this format into one of those?

Alternatively, I could simply use the NOW() function, since I really don't need the time precision. But I read the FAQ about the use of NOW(), and I'm using a variable to do my insert (with several other fields in addition to the date), and the FAQ made it sound like you couldn't use NOW() in a sql string variable.

Thanks

[Drakla]

You can use NOW() in an insert query. You could use [man]strtotime[/man] to convert that string into a unix timestamp, but on my machine I had to get rid of PDT before it would work.

Then in the insert you can use FROM_UNIXTIME($tstamp) in your insert to convert that to a datetime format if you don't want to store time as unix timestamps, which you'd use an INT or INT UNSIGNED column for.