467,146 Members | 1,018 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,146 developers. It's quick & easy.

ASP not displaying time stored in mysql displaying date instead.

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
  • viewed: 2282
Share:
1 Reply
"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.

Similar topics

2 posts views Thread by Marcus | last post: by
2 posts views Thread by Paul Beckett | last post: by
8 posts views Thread by paul@paullee.com | last post: by
1 post views Thread by ian douglas | last post: by
5 posts views Thread by nbohana | last post: by
9 posts views Thread by Bosconian | last post: by
2 posts views Thread by Colleen Robledo, MLIS | last post: by
9 posts views Thread by LayneMitch via WebmasterKB.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.