<div>
This example clearly explain, how to get year. &nbsp;Replace ur variable at getdate function (returns system date)<br />
<br />
1&gt; select getdate()<br />
2&gt; go &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <br />
&nbsp;--------------------------<wbr /> <br />
&nbsp; &nbsp; &nbsp; &nbsp; Mar 29 2003 11:49AM <br />
(1 row affected)<br />
<br />
1&gt; select datepart(year, getdate())<br />
2&gt; go &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <br />
&nbsp;----------- <br />
&nbsp; &nbsp; &nbsp; &nbsp; 2003 <br />
(1 row affected)<br />

</div>


This example clearly explain, how to get year.  Replace ur variable at getdate function (returns system date)

1> select getdate()
2> go                          
 --------------------------
        Mar 29 2003 11:49AM
(1 row affected)

1> select datepart(year, getdate())
2> go            
 -----------
        2003
(1 row affected)


<div>
<div class="content wysiwyg-content">
Does Sybase have year() and month() functions for DATETIME type?
</div>
</div>


Does Sybase have year() and month() functions for DATETIME type?

Sybase Date Functions

Sybase, a subsidiary of SAP, builds a client/server relational database management system. Products include Adaptive Server Enterprise (ASE), Adaptive Server Anywhere (ASA), Sybase Unwired Platform (SUP) for mobile applications, Afaria for enterprise mobile device management and IQ for data warehouse and big data applications.