SYSDATE Year

[twilliamson]

I created the following sql statement. However, I do not want to hardcode the date '01-JAN-2012'. I would like to have 01/01 but derive the year from the sysdate.

Effdt <> TO_DATE('01-JAN-2012','DD/MM/YYYY');

 

[IanWaterman]

This will return the first of the current year

SELECT DATEADD(yy, DATEDIFF(yy, 0, Getdate()), 0) as FirstDayOfYear

Ian

 

[IanWaterman]

Sorry that will not work, I wrongly assumed MYSQL Dateadd and DateDiff worked in same way as SQL server

The syntax you have used looks more like Oracle! Are you in the right forum?

Ian

 

[towerbase]

Assuming you are using MySQL and not some other DBMS then something like this should work:

Effdt <> CONCAT( YEAR( NOW() ), '01-01' )

Andrew

 

[r937]

effdt <> CURRENT_DATE - INTERVAL DAYOFYEAR(CURRENT_DATE)-1 DAY

vwalah

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon