By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,680 Members | 2,139 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,680 IT Pros & Developers. It's quick & easy.

ASP not displaying time stored in mysql displaying date instead.

P: n/a
I seem to be having a problem displaying time stored in mysql. The
format stored in the database is 13:15:05. The database data type is
time. I'm using asp vbscript and sql to retrieve the time store in
the database. However asp recognizes the data type as date and
displays the date instead of the time. If I change the data type in
mysql to varchar then asp will display the time correctly, but I
cannot do it this way. I want to be able to convert the data type in
asp to string from date.
Jul 20 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"Dave Posh" wrote:
I seem to be having a problem displaying time stored in mysql. The
format stored in the database is 13:15:05. The database data type is time. Iím using asp vbscript and sql to retrieve the time store
in
the database. However asp recognizes the data type as date and
displays the date instead of the time. If I change the data type in
mysql to varchar then asp will display the time correctly, but I
cannot do it this way. I want to be able to convert the data type in asp to string from date.


Dave, without having tried this, why canít you use a mysql function
that would convert time to string, and then use the string in your asp
code.

--
http://www.dbForumz.com/ This article was posted by author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbForumz.com/mySQL-ASP-di...ict139789.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbForumz.com/eform.php?p=467792
Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.