Results 1 to 2 of 2

Thread: Todays Date

  1. #1
    Join Date
    Oct 2003
    Location
    CLEVELAND
    Posts
    10

    Unanswered: Todays Date

    Trying to extract data from a SQL Server 2000 database where the Effective_Date=Todays Date.

    The date format that is stored looks like "?/??/??". Am used to Access where you can simply use Effective_Date=Date(). Obviously not working here. I tried GetDate(), GetUTCDate, Sysdate. Lost


    Thanks

  2. #2
    Join Date
    Oct 2003
    Posts
    7
    use convert()

Posting Permissions

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