|
|
Posted by Nicholas Sherlock on 01/06/08 09:50
Skybuck Flying wrote:
> Maybe quotes are needed,
>
> So far this seems to be working:
>
> AND (''06/06/1978'' < ''06/06/1979'')
>
> I'll try using quotes one more time ;)
How is it supposed to know that the text you've provided forms a date?
It doesn't look any different to any other string. In MySQL, dates are
formatted like 2007-01-01, without quotes. In Oracle, you use a to_date
function to convert a string with a format that you supply to a date.
Every database provider has a slightly different flavor. SQL questions
should go to the DBMS provider's forums.
Nicholas Sherlock
Navigation:
[Reply to this message]
|