anyone know....

Results 1 to 2 of 2

Thread: anyone know....

  1. #1
    e Guest

    Default anyone know....

    Anyone know an equivalent function of DateValue() in Access for SQL Server?

  2. #2
    Join Date
    Dec 1969

    Default RE: anyone know....

    If you just want to get the current date from SQL then use the getdate() function.<BR><BR>IE:<BR><BR>SELECT * from TblMyTable WHERE dteDisplay = getdate()-1<BR><BR>Hope this is what you mean.<BR><BR>C.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts