MySQL Forums
Forum List  »  General

Time field display value wrong?
Posted by: temp
Date: February 27, 2005 03:09PM

Hi,

I am encountering some trouble with a `time` field let me explain.

It's very simple actually I use MySQL and ASP classic. I have a `time` field but when I pull the value from MySQL and wish to display errors kick in.

For intance if the value of my `time` field is 00:00:01 I will be treated as a NULL value. On the other han if the value is "12:12:12" it will be printed "27-02-2005" - a date.

The above only occour when the data is pulled from MySQL. I use MySQL Control Center and within it everything is normal and the data is displayed as normal time values.

Any help is greatly appreciated.


Cheers
bjawnie

Options: ReplyQuote


Subject
Written By
Posted
Time field display value wrong?
February 27, 2005 03:09PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.