Jump to content

datetime data type

- - - - -
Started by giuliel, Aug 20 2008 09:14 AM

This topic has been archived. This means that you cannot reply to this topic.
3 replies to this topic

#1
giuliel
Posted 20 August 2008 - 09:14 AM

giuliel

    Learning Programmer

  • Members
  • PipPipPip
  • 60 posts
I'm creating a table and would like to include a date field. However the only option I can find available is the datetime data type which requires me to enter a time as well. All I would like to enter is the date in which an employee was hired. If I don't enter a time is defaults to 12:00:00pm. Is there a data type specifically just for 'date' rather than datetime?
If at first you don't succeed, skydiving is not for you.

#2
Guest_Jordan_*
Posted 20 August 2008 - 10:26 AM

Guest_Jordan_*
  • Guests
Which database are you using?

#3
giuliel
Posted 20 August 2008 - 10:40 AM

giuliel

    Learning Programmer

  • Members
  • PipPipPip
  • 60 posts
Microsoft SQL Server 2000
If at first you don't succeed, skydiving is not for you.

#4
WingedPanther
Posted 20 August 2008 - 12:04 PM

WingedPanther

    A spammer's worst nightmare

  • Moderators
  • 16,831 posts
If you use 12:00:00 AM, it will ignore the time when returning values.
Programming is a branch of mathematics.
My CodeCall Blog | My Personal Blog
Back to Database & Database Programming




  1. CODECALL Programming Forum
  2. → Web Development Forum
  3. → Database & Database Programming
IPB skins by Skinbox