Calculates the User-Defined Function of the last day of a specified year.

/*

Name: fun_yiyuedezuihouyitian

Function: Calculate the last day of the month based on the input format, such as "200311 ".

Parameters:

Benyue this month

Type: Char (6)

Format: 200311"

Returnvalue:

The format is "200310 ".

Type: Char (6)

Steps:

Author: waxdoll Cheung

Date: 2004-04-04

*/

Create Function DBO. fun_yiyuedezuihouyitian

(

@ Benyue char (6)

)

Returns char (10)

As

Begin

Declare @ returnvalue char (2)

Declare @ Yuefen char (2)

Declare @ nianfen char (4)

Set @ Yuefen = right (@ benyue, 2)

Set @ nianfen = left (@ benyue, 4)

If @ Yuefen in ('01', '03', '05 ', '07', '08', '10', '12 ')

Begin

Set @ returnvalue = '31'

End

If @ Yuefen in ('04 ', '06', '09', '11 ')

Begin

Set @ returnvalue = '30'

End

If @ Yuefen = '02'

Begin

If (@ nianfen % 4 = 0 and @ nianfen % 100 <> 0) or (@ nianfen % 400 = 0 ))

Begin

Set @ returnvalue = '29'

End

Else

Begin

Set @ returnvalue = '28'

End

End

Return @ nianfen + '-' + @ Yuefen + '-' + @ returnvalue

End