dcsimg
Results 1 to 2 of 2

Thread: date parts in SQL 6.5

  1. #1
    Join Date
    Mar 2003
    Location
    Minot, ND
    Posts
    4

    date parts in SQL 6.5

    I am still using SQLv 6.5 and have a need to do monthly reports. It is my understanding that there is no inherent capability in SQL v6.5 for functions such as MONTH getdate() as exist in SQL 2000. Does anyone know of a script that will simulate this so I can extract information from a database such as date_last_update IN MONTH 02?

    Thanks

    Dale

  2. #2
    Join Date
    Mar 2003
    Posts
    1
    You can use datepart(month, getdate())

Posting Permissions

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