|
Posted by J.O. Aho on 01/06/08 09:10
Skybuck Flying wrote:
> Only problem remaining is comparing dates with strings (ms access):
I should recommend you took a look at the microsoft-access documentation.
> I tried:
>
> where (Birthday > '01-01-1970')
>
> I tried:
>
> where (Birthday > "01-01-1970")
>
> MS ACCESS or maybe SQL wants the date in a certain format ?
In MySQL you do
WHERE Birthday>19700101
> Maybe there is a function to convert any possible date format ?
DATE_FORMAT
--
//Aho
Navigation:
[Reply to this message]
|