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.
| Author |
Topic |
|
inbs
Aged Yak Warrior
860 Posts |
 Posted - 2009-03-02 : 08:51:08
|
| i have in my DB Column of DateTime like :2009-03-02 12:00:00 AMin the RS i see it as 03/02/2009 12:00:00 AMi want that will be 02/03/2009where i need to change? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-03-02 : 12:56:37
|
| you just need to right click on cell and select properties. then in format tab click on ... next to format box and then select date as type and you've dd/mm/yyyy as one among standard format. just select it. click apply and ok. |
 |
|
|
|
|
|
Data Type-DateTime