Disallowed implicit conversion from data type datetime to data type timestamp

Question

Received error: [Macromedia][SQLServer JDBC
Driver][SQLServer]Disallowed implicit conversion from data type
datetime to data type timestamp, table 'myTbl', column 'duration'.
Use the CONVERT function to run this query.

I have a field named duration hh:mm:ss.lll that I am trying
to insert into MS SQL. DB has field defined as [duration]
[timestamp] NOT NULL,

My insert has this: INSERT INTO myTbl( duration) VALUES(
<cfqueryparam value="2006-05-26 11:12:13"
cfsqltype="CF_SQL_TIMESTAMP"/> )

Why does this not work? rrrrrrrrrrrrrr! BTW: also tried with
seconds as 13.111 which did not work. Does the db duration need to
be date? I just want to store a duration for the time of a movie...
10 Q

Dan_Bracuk · Answer

quote:Originally posted by: quiet1Received error: [Macromedia][SQLServer JDBCDriver][SQLServer]Disallowed implicit conversion from data typedatetime to data type timestamp, table 'myTbl', column 'duration'.Use the CONVERT function to run this query.I have a field named duration hh:mm:ss.lll that I am tryingto insert into MS SQL. DB has field defined as [duration][timestamp] NOT NULL,My insert has this: INSERT INTO myTbl( duration) VALUES(<cfqueryparam value="2006-05-26 11:12:13"cfsqltype="CF_SQL_TIMESTAMP"/> )Why does this not work? rrrrrrrrrrrrrr! BTW: also tried withseconds as 13.111 which did not work. Does the db duration need tobe date? I just want to store a duration for the time of a movie...10 QDuration as a timestamp? How odd, most people would store itas an integer. Or, if you want to build your own string, the syntaxis {ts 'yyyy-mm-dd hh:mm:ss'}. The seconds might not be required.In any event, use createodbcdatetime() for the value you wantto put into your table.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded