Account Log in:

Username:

Password:

*Courage is the ability to do something that, for whatever reason, we instinctively fear*

The Maximum Impact Solutions Blog

July

How Do I Change the format of a DateTime field in SQL?

A client has just asked me how does one format a datetime field in SQL to display the date in the format dd/mm/yyyy?

The SQL Code to convert a field to a specified date time format is:

CONVERT(Data Type(length), field to be converted, Numeric format Code)

So to display todays date in the format dd/mm/yyyy:

CONVERT(varchar(25), Getdate(), 103)

There are a number of different numerical codes, but below are some further SQL code examples of SQL code formatting codes using the current date:

If you have any questions, or need any assistance, please do not hesitate to Contact Us