Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

typemismatch asp formatdatetime

Status
Not open for further replies.

burnside

Technical User
Dec 4, 2004
236
GB
have upgraded testing server to mysql server 4.1
and the odbc3.51 to latest ver and am now getting this error on pages that used to work on 4.0

Type mismatch: 'FormatDateTime'
/dfasp2/dealviewyour.asp, line 433

code-
Response.Write FormatDateTime (x_dealdeltime) & " "

mysql field
12:00:00

datatype
time
 
changed mysql field from 'time' to varchar and now works
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top