Date converted to Varchar.. Want it back
A php application is uploading data to MySql Database.
One of the field is date datatype. However the target field
in the database has the datatype set as varchar.
Now, I want to query the database on this column, however all I
see is just some numbers which dont make any sense. I can still
see the date in the php application using the date("n-j-Y function.
But I really need to see the data from MySql Query browser.
The from_unixtime function in MySql solved solved the issue...
|All times are GMT. The time now is 01:38 AM.|
Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0