How to configure dateformat in database

Question

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Johan Bijnens SSC Guru Points: 135369 More actions · Answer 1

you don't. 😉

- Use datatime datatype for date or time or datetime columns.

This way you are sure valid dates are entered, and you have a bunch of datetime related functions to your availability.

-formatting is a client matter, so this should be done at client side.

If you ensist on formatting date in query analyzer you can user

select convert(char(26), getdate(),121) as mycurrentdatetime

Check books online for more info on convert.

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

su_kumar11 SSCommitted Points: 1675 More actions · Answer 2

SSCommitted

Points: 1675

June 26, 2008 at 6:23 am

I know that query but problem was different.

MannySingh SSChampion Points: 12465 More actions · Answer 3

Do you mean the Server overall(windows or SQL Server)

Pl specify in detail.

Or if it is SQL Server Date Format:

Check BOL for SET DATEFORMAT Syntax

SET DATEFORMAT mdy;

SET DATEFORMAT ydm;