[Resolved] DATE_FORMAT quick question.

[ghjrbrasil]

Is there a way to use the DATE_FORMAT (MYSQL) function to INSERT values (and not just SELECT)?

I'm currently using the DATE_FORMAT to display the date instead of just echoing the datetime field. But lets say I wanted to edit that formated date and insert it back in?

ghjr

[ghjrbrasil]

I could use explode and then put it together accordingly to the datetime format, but I really wanted to know if I could use the DATE_FORMAT.

thanks,
ghjr

[Sxooter]

You should just try it in a mysql session and see if it works.

If it doesn't, then you could always insert the raw data in a temp table and insert it from there:

insert into realtable select date_format(field1...) from temptable;