Skip to content

Commit 94420bd

Browse files
authored
Added sql/sqlsyntax tags
1 parent 21c1430 commit 94420bd

1 file changed

Lines changed: 5 additions & 5 deletions

File tree

docs/t-sql/functions/month-transact-sql.md

Lines changed: 5 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -37,7 +37,7 @@ monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-s
3737

3838
## Syntax
3939

40-
```
40+
```sqlsyntax
4141
MONTH ( date )
4242
```
4343

@@ -56,20 +56,20 @@ MONTH ( date )
5656
## Examples
5757
The following statement returns `4`. This is the number of the month.
5858

59-
```
59+
```sql
6060
SELECT MONTH('2007-04-30T01:01:01.1234567 -07:00');
6161
```
6262

6363
The following statement returns `1900, 1, 1`. The argument for *date* is the number `0`. [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] interprets `0` as January 1, 1900.
6464

65-
```
65+
```sql
6666
SELECT YEAR(0), MONTH(0), DAY(0);
6767
```
6868

6969
## Examples: [!INCLUDE[ssSDWfull](../../includes/sssdwfull-md.md)] and [!INCLUDE[ssPDW](../../includes/sspdw-md.md)]
7070
The following example returns `4`. This is the number of the month.
7171

72-
```
72+
```sql
7373
-- Uses AdventureWorks
7474

7575
SELECT TOP 1 MONTH('2007-04-30T01:01:01.1234')
@@ -78,7 +78,7 @@ FROM dbo.DimCustomer;
7878

7979
The following example returns `1900, 1, 1`. The argument for *date* is the number `0`. [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] interprets `0` as January 1, 1900.
8080

81-
```
81+
```sql
8282
-- Uses AdventureWorks
8383

8484
SELECT TOP 1 YEAR(0), MONTH(0), DAY(0) FROM dbo.DimCustomer;

0 commit comments

Comments
 (0)