Re: FN-FORUM: sql question

date posted 7th August 2004 12:22

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

Hi Pam

It might be worth you looking at the CAST command (if it's MSSQL you're
talking about anyway).

MSDN entry here: http://tinyurl.com/6fvmu

I think you might be able to use it to convert the field to a date.
It's probably quite an inefficient way to do things - if it's something
you have proper access to, I would consider converting the field to a
proper date field - although I appreciate that might be troublesome as
no doubt there's lots of existing code.

HTH,
Dan.

--
http://www.dandylogic.com