Re: SV: Comparing dates

2001-02-19 Thread Nick Didkovsky
Thanks, Pal, I tried that and got an error, which led my down the road to using TO_DAYS() etc... Will try again, and post the error if it reoccurs. Best, Nick Pal Wester wrote: > Actually, there should be a function which does the oposite > of the DATE_FORMAT function, ie. converting a string to

SV: Comparing dates

2001-02-19 Thread Pal Wester
Actually, there should be a function which does the oposite of the DATE_FORMAT function, ie. converting a string to date. but as long as you use mysql notation on dates, you can write ...WHERE myDateField > '2001-02-14'; As I'm in norway and wriote norwegian applications I usually get dates on t