Convert Time String to DATETIME field

Centinul · 09-25-2006, 07:10 PM

What is the best way to convert a time like this:

Code:

Sep 21 12:34:56 2006

To something that MySQL can understand like a DATETIME field? Thanks.

paulsm4 · 09-25-2006, 07:16 PM

Actually, you've a got a whole BUNCH of different options. Especially if you're calling MySQL from PHP.

Anyway, here's a good place to start:
http://dev.mysql.com/doc/refman/5.0/...functions.html

Centinul · 09-25-2006, 07:20 PM

Thanks for the reference. Here is what I ended up using:

Code:

str_to_date('Sep 21 12:34:56 2006','%b %e %T %Y')

Thanks again