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 |
|
venki.dmm
Starting Member
10 Posts |
 Posted - 2008-09-18 : 06:13:33
|
| Hi all I am working in sql server my dateformat is in yyyy-mm-dd HH:MM:SS (varchar)i want to convert in to yyyy-mm-ddcan you please help meRegardsvenki |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-18 : 06:18:57
|
| Do this at your front end application if this is for display purpose. |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-09-18 : 06:19:18
|
quote:
Originally posted by venki.dmm
Hi all I am working in sql server my dateformat is in yyyy-mm-dd HH:MM:SS (varchar)i want to convert in to yyyy-mm-ddcan you please help meRegardsvenki
Where do you want to show converted dates?MadhivananFailing to plan is Planning to fail |
|
|
|
venki.dmm
Starting Member
10 Posts |
Posted - 2008-09-18 : 06:29:14
|
| Hi visakh16this to display purpose.in reports Businss objectsRegards,venki |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-18 : 06:39:38
|
quote:
Originally posted by venki.dmm
Hi visakh16this to display purpose.in reports Businss objectsRegards,venki
then do formatting in reports. which is report application you're using? |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-09-18 : 06:49:32
|
quote:
Originally posted by venki.dmm
Hi visakh16this to display purpose.in reports Businss objectsRegards,venki
Right click on the fieldselect format fieldchoose the formatMadhivananFailing to plan is Planning to fail |
|
|
|
venki.dmm
Starting Member
10 Posts |
Posted - 2008-09-18 : 06:57:28
|
| Hi madhivananI have created new object and chaged the format also .. |
|
|
|
|
|
|
Help me in date Format