.
()
(VALUEISFILLED)
, , NULL, , . NULL. .
(SERIALNUMBER)
.
()
(GROUPSERIALNUMBER)
.
()
(FORMAT)
. 1:.
:
● ,
● .
(., "=2")
(BEGINOFPERIOD)
. :
● ;
● , :
,
,
,
,
,
,
,
,
.
((2009, 10, 12, 10, 15, 34), "")
:
01.10.2009 0:00:00
(ENDOFPERIOD)
. :
● ;
● , :
,
,
,
,
,
,
,
,
.
((2009, 10, 12, 10, 15, 34), "")
:
13.10.2009 23:59:59
(DATEADD)
. :
● ;
● , :
● ,
● ,
● ,
● ,
● ,
● ,
● ,
● ,
● ,
● .
● . . .
((2009, 10, 12, 10, 15, 34), "", 1)
:
12.11.2009 10:15:34
(DATEDIFF)
. :
● ;
● ;
● :
● ,
● ,
● ,
● ,
● ,
● ,
● .
((2009, 10, 12, 10, 15, 34), (2009, 10, 14, 9, 18, 06), "")
:
|
|
(CURRENTDATE)
. , , .
()
(SUBSTRING)
. :
● , ;
● , ;
● .
(., 1, 4)
(STRINGLENGTH)
. .
(.)
(YEAR)
. , .
(.)
(QUARTER)
. 1 4. , .
(.)
(MONTH)
. 1 12. , .
(.)
(DAYOFYEAR)
. 1 365 (366). , .
(.)
(DAY)
. 1 31. , .
(.)
(WEEK)
. , 1. , .
(.)
(WEEKDAY)
. 1 () 7 (). , .
(.)
(HOUR)
. 0 23. , .
(.)
(MINUTE)
. 0 59. , .
(.)
(SECOND)
. 0 59. , .
|
|
(.)
(CAST)
, . , , NULL. :
● ;
● , . , , . . . .
(.1, "(10,3)")
NULL (ISNULL)
, NULL. .
NULL((.), 0)