stored procedure

[site]

Hi, All,

Would you please tell me how to write stored procedure that return 'last day of the current year'?

Thank you a lot.
Jing

 

[foxdev]

Return it as what data type? DateTime? Character? Robert Bradley
Support operation moo!
Visit the OpCow page

http://www.agrainofhope.org/opcow.shtml

to help in this cause

 

[site]

Hi, Robert,

Thanks for your quickly reply. I need this stored procedure to return last date(daytime)of the current year.

Thanks again.

 

[foxdev]

One solution:

[tt]select convert(datetime, '12/31/' + convert(char(4), datepart(yy, getdate()) ))[/tt]

I prefer CAST to CONVERT, but I had to test this in Sybase before posting (don't ask), and Sybase doesn't support CAST. Robert Bradley
Support operation moo!
Visit the OpCow page

http://www.agrainofhope.org/opcow.shtml

to help in this cause

 

[site]

Robert,

Thank you very much.
Jing