Discuss "date problem" in the SQL Development forum.

todd2006 · #1 (**permalink**) May 12th, 2008, 01:47 PM

Hi,

I have this sql code

Code:

str="SELECT * FROM Registration  where ExpirationDate < 
getdate() order by convert(smalldatetime,ExpirationDate) desc"

it gives me an error like

The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.

ExpirationDate is a varchar field

todd

mehere · #2 (**permalink**) May 12th, 2008, 01:51 PM

you need to convert the field, like you did in your ORDER BY clause ... like so

Code:

str="SELECT * FROM Registration  where convert(smalldatetime,ExpirationDate) < 
getdate() order by convert(smalldatetime,ExpirationDate) desc"

why is it your date field is a varchar type and not a date type?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Display Assembly File Date And Time	Wolffy	.Net	0	April 9th, 2008 11:57 AM
Date Last Modified for ASP Pages	mehere	Classic ASP	0	March 21st, 2008 12:20 PM

LinkBacks (?) LinkBack to this Thread: http://www.developerbarn.com/sql-development/180-date-problem.html
Posted By	For	Type	Date
Team Wolfguard Solutions - Resources	This thread	Refback	May 14th, 2008 03:11 PM

Discuss "date problem" in the SQL Development forum.

SQL Development - Structured Query Language (SQL) is the talk of databases. Discuss topics such as joins, triggers and other advanced SQL topics.