SQLserv. I want to INSERT time, without date HELP

[Joe Resudek]

I'm trying to INSERT just the time with a SQL statement. When I do the
insert, I get 1/1/1900 plus the time I specified. I want to exclude the
date portion all together.

The field type is datetime.

How to I accomplish this???

--
Joe Resudek
Frontier New Media
225 Crummer Lane
Reno, NV 89509
(775) 824-4040
(775) 824-4044 fax
[url]http://www.thefrontiergroup.com[/url]

[Aaron Bertrand - MVP]

"Joe Resudek" <joe@thefrontiergroup.com> wrote in message
news:#s8vjoPXDHA.1900@TK2MSFTNGP10.phx.gbl...

> I'm trying to INSERT just the time with a SQL statement. When I do the
> insert, I get 1/1/1900 plus the time I specified. I want to exclude the
> date portion all together.
>
> The field type is datetime.
>
> How to I accomplish this???

Not with a DATETIME column. You either ignore the DATE portion (since it
will be the same for all values anyway), or use a different datatype.

See [url]http://www.aspfaq.com/2206[/url] for some potential workarounds.

[John Beschler]

Aaron,

Is [url]www.aspfaq.com[/url] your website? I notice you refer to it a
lot.

Just wanted to say I think you (whoever) have done a great
job with this site. It's easy to use and easy to read. The
examples are clear and the layout is simple yet nice
looking.

Thanks for all your hard work,
John

[Aaron Bertrand - MVP]

Yes, thanks for the comments...

A



"John Beschler" <giles@geewhiz.com> wrote in message
news:009e01c35d05$571e9eb0$a401280a@phx.gbl...

> Aaron,
>
> Is [url]www.aspfaq.com[/url] your website? I notice you refer to it a
> lot.
>
> Just wanted to say I think you (whoever) have done a great
> job with this site. It's easy to use and easy to read. The
> examples are clear and the layout is simple yet nice
> looking.
>
> Thanks for all your hard work,
> John
>