Just the date

Results 1 to 2 of 2

Thread: Just the date

  1. #1
    Luk Guest

    Default Just the date

    I have a sql server database with a smalldatetime column.<BR>When I use getdate() to update the field it adds the time also.<BR>How can I insert just the date into this field?

  2. #2
    Join Date
    Dec 1969
    Los Angeles, CA

    Default RE: Just the date

    insert convert(varchar(10), getdate(), 101) into your column<BR><BR>

Posting Permissions

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