Get/Select YY out of DATE

[MichaelLewis]

How do I get the YY out of my Database trdate (defined as DATE)?

i.e., I want to
SELECT * FROM transactions WHERE user = '$UserID' AND trdate = '$yy'

($yy is a 2 digit year)

Thanks,
Michael

 

[r937]

AND YEAR(trdate) = $yy /* note no quotes */

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

 

[imex]

Try something like that:

SELECT * FROM transactions WHERE user = '$UserID' AND Convert(char(2), trdate, 2) = '$yy'

I hope this helps.

Casas a venda em Suzano

 

[r937]

oh wait... i just realized my solution (above) will not work unless $yy is a 4-digit year

can you arrange that?

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

 

[MichaelLewis]

This solution
...AND Convert(char(2), trdate, 2) = '$yy'
does not work.

I used the first solution, YEAR(trdate)='$yy' (with quotes) but I first added 2000 to my $yy. My application's data will not go back to the 1900's and I'm sure it wont be used past the expiration of the 2000's.

Many thanks for your help,
Michael

 

[r937]

YEAR() produces an integer, not a string

no sense forcing a string-to-integer conversion -- i still think you should remove the quotes from $yy



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