|
Subject:
|
Help me !
|
|
Posted By:
|
minhtri
|
Post Date:
|
6/4/2004 12:38:15 AM
|
How to Retries the Recordset by
SELECT * FROM TABLENAME WHERE Filename=today ?
|
|
Reply By:
|
snowbelly
|
Reply Date:
|
6/4/2004 3:31:01 AM
|
SELECT * FROM TABLENAME WHERE Filename='Format(Now(),'dd-mm-yyyy')'
is this what you mean?
|
|
Reply By:
|
Lalit_Pratihari
|
Reply Date:
|
9/29/2004 9:52:12 AM
|
Hi,
You can also use the GETDATE() function available in SQL Server.
SELECT * FROM TABLENAME WHERE FILENAME = CONVERT(VARCHAR(10), GETDATE(), 110)
Thanks,
Lalit
Life Means More...
|
