help concatenating date fields into real date field
Posted 14 June 2003 - 11:25 PM
month (in long format like July)
I need to create an update script that will take these three fields and give me a mysql date field.
Can anyone help with this?
Posted 16 June 2003 - 12:39 AM
why not just use one?
e.g \"date_field DATETIME\" or maybe \"date_field TIMESTAMP\"
..date maniupualtion would be easier i think
Posted 16 June 2003 - 12:42 AM
Posted 16 June 2003 - 08:52 AM
You can rewrite the long format to numeric format using the case:
END) as month_numeric;
So you\'ll end up with:
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users