RE: FN-FORUM: sql question

date posted 7th August 2004 12:21

It would depend on the exact flavour of sql.

I suggest you look at the database manufacturers web site for info on their
date functions but if that does not help and there is no conversion routine
then you should be able to split the string into it's components are
concatenate them into the format yyyymmdd which could be used in the range
check, this would however not be very efficent since it would preclude the
use of any indexing on that field.



-----Original Message-----
From: [EMAIL REMOVED] [EMAIL REMOVED] On Behalf Of PAMELA
WHITTAKER
Sent: 07 August 2004 13:05
To: FN-FORUM / [EMAIL REMOVED]
Subject: FN-FORUM: sql question



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
converting it to a date format in the select statement?

Thanks
Pam


--
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