1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

how to insert only date in datetime column of a table

Discussion in 'SQL Server' started by shyam_oec, Mar 29, 2010.

  1. shyam_oec

    shyam_oec New Member

    Joined:
    Nov 26, 2007
    Messages:
    89
    Likes Received:
    1
    Trophy Points:
    0
    Occupation:
    Software Developer, .NET Framework
    Location:
    Jamshedpur
    Hi, i have a table, with a column having datetime type.But i want to insert only date in that field ,and not time.Is it possible?
    If possible how?
    Thanks
     
  2. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,292
    Likes Received:
    365
    Trophy Points:
    83
    Yes but you have to validate that from either front end or from some procedures
     

Share This Page