SQL Reporting Services Tips  

Main | About us | Contact us  

 

4) Useful formatting codes

Format Code

Format

MMM yyyy

Jan 2000

dd/MM/yyyy

01/01/2000

dd/MM/yyyy HH:mm:ss

01/01/2000 14:00:00

dd/MM/yyyy hh:mm:ss tt

01/01/2000 02:00:00 PM

dd/MM/yyyy HH:mm

01/01/2000 14:00

dd/MM/yyyy hh:mm tt

01/01/2000 02:00 PM

Empty Empty
Empty Empty
Empty Empty
Empty Empty
Empty Empty
Empty Empty
Empty Empty
Empty Empty
Empty Empty
Empty Empty
Empty Empty
Empty Empty
Empty Empty
Empty Empty
Empty Empty
Empty Empty

© Copyright 2009. Reporting Services Tips.