SQL Server Database Date Time Values

35 pts.
Tags:
SQL Server 2000
SQL Server database
I am developing a software using Date Time values. i am using SQL server 2000 as the database. can i create a coloumn with only time value or data value. Only datetime is available. how can i eliminate a part of it in the database. when inserting the time values the date part is 01 jan 1900. i want 2 eliminate that date part from the structure also .please suggest an answer.

Answer Wiki

Thanks. We'll let you know when a new response is added.

This can’t be done in SQL 2000 as long as you are using the DATETIME data type. Microsoft didn’t begin offering the DATE and the TIME data types until SQL Server 2008 was released.

You’ll need to store the entire datetime value and then only display the part that you need.

You might consider upgrading to SQL Server 2008 instead of SQL Server 2000 if this is for a new project.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following