Results 1 to 2 of 2
Nov 30, 2008, 14:28 #1
- Join Date
- Jan 2002
- Omaha, NE
- 0 Post(s)
- 0 Thread(s)
Coldfusion, SQL Server 2005, and dates
I'm having some issues with coldfusion inputing dates into my db. I'm using sql 2005 with coldfusion 8. When I goto enter a date either as string (11/30/2008 09:30:45) or with the getDate() function it drops the time and enters 12:00:00 when done through coldfusion. If I run the same query in the SQL Server Enterpise manager it enters the date perfectly, with the correct time.
Has anyone ever encountered this problem or have any suggestions on a course of actino to correct it?"Oh, you hate your job? Why didn't you say so? There's a support group for that.
It's called EVERYBODY, and they meet at the bar."
Nov 30, 2008, 22:01 #2