|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
April 26th, 2005, 02:39 PM
|
|||
|
|||
|
Date/Time in SQL
Hey again, i'm trying to get CF to put the date or date/time into the SQL 2003 date/time field.
So far i've tried a few things, I thought this was going to work... insert into history (daytime) values ('#DateFormat(CreateODBCDate(now()), "DDMMYYYY")#') my error was Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. the SQL date/time field is 8 characters long, so, I don't know the best way to go about shoving a date/time into it in CF. Thanks
|
|
#2
April 26th, 2005, 02:46 PM
|
|||
|
|||
|
Nevermind, I suppose I don't need to use the specified date/time field...if I change the field to varchar it works no problem. Although, it seems like a lame work around to me
|
|
#3
May 1st, 2005, 05:53 PM
|
|||
|
|||
|
Question
Quote:
 What is SQL 2003? What is your db?I've used the CreateODBCDate() function sucessfully in inserts to MS SQL Server 2000 and MySQL with no issues as long as the colum data type is defined correctly. Mark Holm
|
|
| Viewing: Dev Shed Forums > Programming Languages - More > ColdFusion Development > Date/Time in SQL |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
