Post reply

declaring time

  • April 19, 2014 at 5:12 am

    #285890

    i want to declare in my sql table day,hours and minutes how can i set the format type for that can any one explain me please..................:-)

  • April 19, 2014 at 5:24 am

    #1707247

    anyone help me yar

  • April 19, 2014 at 5:41 am

    #1707248

    To store date and time information in a table, I would recommend the DATETIME2 data type.

    It's not very clear why you would store the date parts separately. There are scenarios, where it's useful, but more often it does more harm than it helps...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply