Mysql CAST

pokahantas · #1 (**permalink**) 10-20-05, 13:05

Hi !

Does anyone know how to cast a string date like '2005-10-12 12 : 15 : 00' in a DATETIME format in an Update query ?
Thank you.

jfulton · #2 (**permalink**) 10-20-05, 13:27

Code:

SELECT TIMESTAMP( str_to_date( '2005-10-12 12:15:00', '%Y-%m-%d %H:%i:%s' ) )

pokahantas · #3 (**permalink**) 10-20-05, 14:15

It works with timestamp. In my case, i use it in an update query and it is working very well.
Thank you.

khibinite · #4 (**permalink**) 10-20-05, 16:38

Hi!

May you clarify what do you mean: would u like to update every record in the table?