Hi All
I'm completely new to MySql to don't laugh too loud if this is a really stupid question.
I need to query data from a MySql database based on a date field but I notice all the date fields appear to be stored as numeric data types, see below:
I was expecting to see dates as they are stored in SQL Server, i.e. 01/09/2007 11:23:47.
How do I translate the MySql date value into something more meaningful.
I.e. How do I convert 1115904879 into a dd/mm/yyyy hh:mm:ss format?
TIA
Smeat
I'm completely new to MySql to don't laugh too loud if this is a really stupid question.
I need to query data from a MySql database based on a date field but I notice all the date fields appear to be stored as numeric data types, see below:
Code:
Ticket_ID Opened_Date Closed_Date
1 1115904879 0
2 1116515087 1116515801
3 1118401271 0I was expecting to see dates as they are stored in SQL Server, i.e. 01/09/2007 11:23:47.
How do I translate the MySql date value into something more meaningful.
I.e. How do I convert 1115904879 into a dd/mm/yyyy hh:mm:ss format?
TIA
Smeat