Date converted to Varchar.. Want it back
 

Hello Experts,

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.

Any suggestions..:-/

^^

The from_unixtime function in MySql solved solved the issue...