Select FORMATDATE([ColumnName],"dd,MMMM,yyyy")

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Other SQL Server Topics (2005)

Select FORMATDATE([ColumnName],"dd,MMMM,yyyy")

Author

Topic

MATTXtwo
Starting Member

4 Posts

Posted - 2008-10-15 : 23:38:23

can I have data from table which I can format date like
'12 September 2008' on the query

BRINGING LITE CONTENTS

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-10-16 : 00:26:13

You can't control how your data is stored when using datetime data type, but you can control how it is returned out of the database. This is really a presentation issue and should be handled in your application, but if you must do it in T-SQL then you can use CONVERT function.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources