Christian et Karen SKARNIAK-MARKLAND
|
| Posted: 01/02/2003, 2:24 PM |
|
I'd like to compare a date in my database (Mysql) with the date of the day -
for exemple in SQL query.
Where .....>= ....
How can i do ??????????
thanks
|
|
|
 |
DonB
|
| Posted: 01/02/2003, 3:18 PM |
|
I'll assume you are using ASP:
The DatePart function will return the day: DatePart ("d",now()) returns "2"
(today is Jan 2nd). If you want the # of days since Jan 1st, use"y" instead
of "d" (on Feb 1st it would return "32").
DonB
"Christian et Karen SKARNIAK-MARKLAND" <cskarniak@free.fr> wrote in message
news:av2e6b$nrt$1@news.codecharge.com...
> I'd like to compare a date in my database (Mysql) with the date of the
day -
> for exemple in SQL query.
>
> Where .....>= ....
>
> How can i do ??????????
>
> thanks
>
>
|
|
|
|
|
