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 |
|
paramu
Posting Yak Master
151 Posts |
 Posted - 2010-04-10 : 05:30:52
|
| The data from the table is like the below.04-10-2010 : 12:00:00 ....But I want to select as dd/MM/yy like 10/04/10 Is it possible?My QuerySelect Invoice_Date from Invoice_Master...........?ThanksParamu @ PARANTHAMAN |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-04-10 : 05:34:33
|
You should format data in your front end application, and not at the SQL Server end.If that is not possible useSelect CONVERT(varchar(8), Invoice_Date, 103) from Invoice_Master |
 |
|
|
paramu
Posting Yak Master
151 Posts |
Posted - 2010-04-10 : 05:41:08
|
| Thanks Kristen....Paramu @ PARANTHAMAN |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-04-10 : 07:16:04
|
| changing datatype for just formatting really makes date manipulations difficult. thats why we suggest to do this @ front end whenever you can------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
SQL Server Datetime Field - Select as dd/mm/yy ?