Date & Time format - SQL Server Forums

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

Other Forums

MS Access

Date & Time format

Author

Topic

d00d101
Starting Member

3 Posts

Posted - 2009-04-09 : 11:09:31

I want the following date and time to be formatted to: mm/dd/yyyy/time

2008/12/31/23524800

Table -- [Issues Combined]
Field -- [Issue Date]

Can anyone help?

Thanks!

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-04-10 : 05:09:34

Try using format function

Madhivanan

Failing to plan is Planning to fail

Sequin
Starting Member

25 Posts

Posted - 2009-04-16 : 06:48:50

You need to do some string slicing

mid("2008/12/31/23524800",6,2) & "/" & mid("2008/12/31/23524800",9,2) & "/" Left("2008/12/31/23524800",4) & "/" & Right("2008/12/31/23524800",8)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources