Results 1 to 2 of 2

Thread: Getdate() Function

  1. 11-16-2000, 04:10 PM #1
    Tim Guest

    Getdate() Function

    The getdate () function returns the following
    eg: 2000-11-16 16:13:49.717

    Do anyone knows of a function to return only the date eg: 2000-11-16???
    Not the time.

    Thanks!

    Reply With Quote Reply With Quote
  2. 11-16-2000, 04:35 PM #2
    jeniffer Guest

    Getdate() Function (reply)


    select convert(varchar(12),getdate(),111)

    ------------
    Tim at 11/16/00 4:10:50 PM

    The getdate () function returns the following
    eg: 2000-11-16 16:13:49.717

    Do anyone knows of a function to return only the date eg: 2000-11-16???
    Not the time.

    Thanks!

    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules