Formatting the date on insert

subnet_rx · #1 (**permalink**) 11-22-04, 15:50

I have learned how to format the date coming out of a database, but if I have a user enter the date in the format 08/04/2004, how can I change that to 2004-08-04?

Sudar · #2 (**permalink**) 11-25-04, 01:43

Try the following

select from_unixtime(unix_timestamp('08/04/2004'))

Let me know whether this solved ur problem

subnet_rx · #3 (**permalink**) 11-25-04, 11:48

actually, I have decided to just use a calendar to let the user select a date and it inputs it into the form. It was just more convenient than formatting dates going in and out, on every query.

guelphdad · #4 (**permalink**) 11-25-04, 13:08

Sudar, I just tried what you have above on mysql 5.x
It gives a date sometime in 1969.

Sudar · #5 (**permalink**) 11-25-04, 23:44

You r correct guhelpdad, thnks for pointing it out to me

Unix_timestamp accepts date in yyyy-mm-dd format only..
so only the following will work

select from_unixtime(unix_timestamp('2004-08-20'));

Internet Services

Web Development

Digital Marketing

Consumer Tech