Storing Date
From: Leila (Leilas_at_hotpop.com)
Date: 01/22/05
- Next message: Aaron [SQL Server MVP]: "Re: Storing Date"
- Previous message: Adam Clauss: "Identity column: what happens when it runs out?"
- Next in thread: Aaron [SQL Server MVP]: "Re: Storing Date"
- Reply: Aaron [SQL Server MVP]: "Re: Storing Date"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 23 Jan 2005 00:54:23 +0330
Hi,
When I insert a time, the default date is added to the column too. Is it
possible to prevent it?
How can I discard the date when I want to show this column to user?
This is the code that I run:
CREATE TABLE MyTest(
Col1 DATETIME)
INSERT MyTest VALUES('10:22')
Thanks,
Leila
- Next message: Aaron [SQL Server MVP]: "Re: Storing Date"
- Previous message: Adam Clauss: "Identity column: what happens when it runs out?"
- Next in thread: Aaron [SQL Server MVP]: "Re: Storing Date"
- Reply: Aaron [SQL Server MVP]: "Re: Storing Date"
- Messages sorted by: [ date ] [ thread ]