|
Home > Archive > ASE Database forum > October 2005 > retrieve year from dateTime field
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
retrieve year from dateTime field
|
|
|
| how to retrieve "year" from datetime field. in mysql , we just use
year(datetimefield) , how to do that in sybase ase?
| |
| Carl Kayser 2005-10-27, 8:21 am |
| Either "select datepart (year, <datetime> )" or "select datepart (yy,
<datetime> )".
Note that this returns an integer value for the century/year, e.g., 2005
(versus a year value between 00 and 99).
"j" <j@sybase.zcd.com> wrote in message news:434b8c56@forums
-2-dub...
> how to retrieve "year" from datetime field. in mysql , we just use
> year(datetimefield) , how to do that in sybase ase?
>
>
| |
| Bret Halford 2005-10-27, 8:21 am |
|
j wrote:
> how to retrieve "year" from datetime field. in mysql , we just use
> year(datetimefield) , how to do that in sybase ase?
As of ASE 12.5.1, you can use
select year(datetimefield)
In prior versions, you would use datepart().
-bret
|
|
|
|
|