Results 1 to 2 of 2

Thread: datetime format in table design

  1. #1
    Join Date
    Aug 2005
    Posts
    3

    Question datetime format in table design

    Good Day, nicholas here! Can i know is there any way to change datetime format to 13:00:01(hh:mm:ss) in Microsoft SQL Server 2000 Enterprise Manager's table ... Please help me!

    Many Thanks!

  2. #2
    Join Date
    Sep 2002
    Posts
    169
    SQL Server does not store datetime formats. It is up to the user to decide how he/she wants to see it. Have a look at the Convert function.

Posting Permissions

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