RE: FN-FORUM: sql question

date posted 7th August 2004 13:45

For SQL Server;

Convert(datetime, datefield, 3)

If you're using YYYY then use 103

Converts your text into date format.

I always pass my dates in and out of stored procedures using varchars as
DD/MM/YYYY

Then convert the varchar into datetime fields in the stored procedure.

Cheers
Andy

-----Original Message-----
From: [EMAIL REMOVED] [EMAIL REMOVED] On Behalf Of Andy
Stafford
Sent: Saturday, August 07, 2004 1:18 PM
To: Andy Macnaughton-Jones
Subject: Re: FN-FORUM: sql question


PAMELA WHITTAKER wrote:

> I have a date stored as dd/mm/yy as a vchar in an sql database. How do

> I write an sql statement to select a date range? Is there some way of=20
> converting it to a date format in the select statement?

If it is MSSQL, you could try

http://msdn.microsoft.com/library/en-us/tsqlref/ts_ca-co_2f3o.asp

or use SUBSTRING

substring(datefield,7,2) + substring(datefield,4,2) +
substring(datefield,1,2)

Either way is going to be innefficient compared to just converting them
to date data type, the second way will land you in prison.


--=20
http://www.dandylogic.com


--=20
Freelancers, contractors earn more with Prosperity4
Call 0870 870 4414 or visit www.prosperity4.com
and benefit from Inland Revenue approved expenses today.

To advertise here: http://www.freelancers.net/advertising.html