Results 1 to 2 of 2

Thread: Dates in SQL 6.5

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

    Post Dates in SQL 6.5

    I am still using SQLv6.5 and have a need to do monthly reports. it is my understanding that there is no inherent capability in 6.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
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    You can use datepart function like

    select 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
  •