Date and Time Formatting example

For date and time formatting use this command:-

select convert(varchar(30),getdate(),100)

output is:

Jan 11 2011 7:52PM

In the Convert function:

1)varchar(30): length of the string to be displayed

in the output:

2)getdate():current date

3)100: style number

Try with these style numbers
1 to 14
20 to 25
100 to 114
120 to 121, 126, 127, 130, 131



Some other styles:

i)style number:-105

The output
11-01-2011

ii) style number:-114

The output

19:53:07:230