Ms Misery (MsMisery)
Nineteen years ago (Monday, 11th December 2006)
I have a simple thing that I’m trying to do and can’t make it work. Please help my stupid brain.
HTML form (processed with PHP), user-entered date, insert to MySQL as smalldatetime. How?
I can’t convert the user-entered string to make it go in as a date. In the end I need to sort by these dates. There has to be a way.
jw (ex machina)
Nineteen years ago (Monday, 11th December 2006)
Mysql’s date format is different. I don’t know it offhand but you should read the input date with:
and then
use FROM_UNIXTIME (32498892345982) around the unix timestamp in your sql
Ms Misery (MsMisery)
Nineteen years ago (Monday, 11th December 2006)
hmm, I will try this. after lunch!
Oddly enough, staying here I saw seven golden bowls make cakes and religion (goo
Nineteen years ago (Tuesday, 12th December 2006)
MySQL: All the fucked-up datatypes of MSSQL, but none of the handy casts.
M Grout (Mark Grout)
Nineteen years ago (Tuesday, 12th December 2006)
SmallDateTime.
What’s that all about then?