Hello.
On Sun 2002-12-08 at 16:03:22 -0500, [EMAIL PROTECTED] wrote:
>
> I am trying to store a date in the following format '08/12/2002' pr
> '08/12/2002' or any other format if I have to ...on SQLServer 7.
This is the mysql list. What has SQLServer 7 to do with MySQL?
> Basically I want to use
>
> TodaysDate = Date ' Date is the system date function
>
> strSQL = "SELECT * FROM CallBacks WHERE CallDate =" & TodaysDate
>
> Is there any good way to follow please ??
Probably any RDBMS has a built-in date type. Declare CallDate to be of
that type. For MySQL that would be DATE. Then you can use something like
SELECT * FROM CallBacks WHERE CallDate = CURDATE()
If you are really referring to a different RDBMS, CURDATE() may have a
different name.
HTH,
Benjamin.
--
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
