SitePoint Sponsor

User Tag List

Results 1 to 3 of 3

Thread: SQL Server 2k

  1. #1
    SitePoint Addict
    Join Date
    Jun 2001
    Location
    Malaysia
    Posts
    352
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    SQL Server 2k

    Hi guys,

    I'm wondering if there's a reference available for all data types in SQL Server 2k? I'm confused about the "datetime" data type... mm/dd/yyyy? or dd/mm/yyyy?

    A URL reference (or MS KB) would be greatly appreciated

  2. #2
    SitePoint Wizard westmich's Avatar
    Join Date
    Mar 2000
    Location
    Muskegon, MI
    Posts
    2,328
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    http://msdn.microsoft.com/library/de...da-db_7msw.asp
    There are a couple of date/time data types, but for the most part they will work with any standard dates.

    January 1, 2002
    1-01-02
    Jan-01-2002
    1/01/02 12:00:00
    etc...
    Westmich
    Smart Web Solutions for Smart Clients
    http://www.mindscapecreative.com

  3. #3
    SitePoint Addict
    Join Date
    Jun 2001
    Location
    Malaysia
    Posts
    352
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    thanks!


Bookmarks

Posting Permissions

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