Re: sql server 2000
- From: "Hari Prasad" <hari_prasad_k@xxxxxxxxxxx>
- Date: Fri, 15 Jul 2005 02:36:50 +0530
Hi,
See Functions DATEPART and CONVERT in books online.
Thanks
Hari
SQL Server MVP
"Wendy Elizabeth" <WendyElizabeth@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:2098B955-D0AF-4C4D-A7FC-930EFC2CB6BC@xxxxxxxxxxxxxxxx
>I just started to work with sql server 2000. I want to write a query
>
> against "datetime" columns in the sql server 2000 database. I am to be
>
> able to do the following with the sql server 2000 "datetime" columns:
>
> 1. Be able to access the date portion only.
> 2. Be able to access the time portion only.
> 3. Be able to access only a portion of the date like the month and/or
>
> year only.
> 4. Be able to access only a portion of the time like the milliseconds
>
> and/or the minutes.
>
> What kind of query statements would I need to write, to be able to
>
> access only a portion of "datetime" columns?
>
> Thanks!
>
.
- References:
- sql server 2000
- From: Wendy Elizabeth
- sql server 2000
- Prev by Date: sql server 2000
- Next by Date: N prefex in a non-unicode database
- Previous by thread: sql server 2000
- Next by thread: Re: sql server 2000
- Index(es):
Relevant Pages
|
|
