Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

c# asp.net - (datetime) SQL Formatting

Status
Not open for further replies.

AtomicChip

Programmer
May 15, 2001
622
CA
I know this is a stupid question, but...

All I want to do is insert a time (hh:mm) into the database field (datatype=datetime). I've tried using String.Format, but no matter how I try dumping the data into the database, the database (SQL2000) keeps prefixing the time with 1/1/1900. How do I get rid of this? -----------------------------------------------
"The night sky over the planet Krikkit is the least interesting sight in the entire universe."
-Hitch Hiker's Guide To The Galaxy
 
I think this question might have a better chance of being answered from the guys & gals in the SQLServer forum.

I've never had the occasion where all I needed was a time, and judging from the lack of response here, doesn't look like many others here have, either.

:-(
penny1.gif
penny1.gif
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top