View Single Post
Old 07-06-2009, 01:41 PM   #1 (permalink)
skv
The Wanderer
 
Join Date: Jun 2009
Posts: 7
Thanks: 0
skv is on a distinguished road
Confused 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..
skv is offline  
Reply With Quote