Online Documentation for SQL Management Studio for Oracle

Format specifiers

Date/Time format

d

Displays the day as a number without a leading zero (1-31).

 

dd

Displays the day as a number with a leading zero (01-31).

 

ddd

Displays the day as an abbreviation (Sun-Sat) using the strings of the Short Day Names.

 

dddd

Displays the day as a full name (Sunday-Saturday) using the strings of the Long Day Names.

 

ddddd

Displays the date using the Short Date Format.

 

dddddd

Displays the date using the Long Date Format.

 

e

Displays the year in the current period/era as a number without a leading zero (Japanese, Korean and Taiwanese locales only).

 

ee

Displays the year in the current period/era as a number with a leading zero (Japanese, Korean and Taiwanese locales only).

 

g

Displays the period/era as an abbreviation (Japanese and Taiwanese locales only).

 

gg

Displays the period/era as a full name. (Japanese and Taiwanese locales only).

 

M

Displays the month as a number without a leading zero (1-12). If the m specifier immediately follows an h or hh specifier, the minute rather than the month is displayed.

 

MM

Displays the month as a number with a leading zero (01-12). If the mm specifier immediately follows an h or hh specifier, the minute rather than the month is displayed.

 

MMM

Displays the month as an abbreviation (Jan-Dec) using the strings given of the Short Month Names.

 

MMMM

Displays the month as a full name (January-December) using the strings of the Long Month Names.

 

yy

Displays the year as a two-digit number (00-99).

 

yyyy

Displays the year as a four-digit number (0000-9999).

 

h

Displays the hour without a leading zero (0-23).

 

hh

Displays the hour with a leading zero (00-23).

 

m

Displays the minute without a leading zero (0-59).

 

mm

Displays the minute with a leading zero (00-59).

 

s

Displays the second without a leading zero (0-59).

 

ss

Displays the second with a leading zero (00-59).

 

z

Displays the millisecond without a leading zero (0-999).

 

zzz

Displays the millisecond with a leading zero (000-999).

 

t

Displays the time using the Short Time Format.

 

tt

Displays the time using the Long Time Format.

 

am/pm

Uses the 12-hour clock for the preceding h or hh specifier, and displays 'am' for any hour before noon, and 'pm' for any hour after noon. The am/pm specifier can use lower, upper, or mixed case, and the result is displayed accordingly.

 

a/p

Uses the 12-hour clock for the preceding h or hh specifier, and displays 'a' for any hour before noon, and 'p' for any hour after noon. The a/p specifier can use lower, upper, or mixed case, and the result is displayed accordingly.

 

ampm

Uses the 12-hour clock for the preceding h or hh specifier, and displays the contents of the TimeAMString global variable for any hour before noon, and the contents of the TimePMString global variable for any hour after noon.