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 |
|
desikankannan
Posting Yak Master
152 Posts |
 Posted - 2008-08-12 : 07:17:32
|
| hi,iam working in vb.net application i have datetime field, i want to store the date like 12/08/2008 but in sql 2005 it storing 08/12/2008, looking forward your suggestionsi want to display dd/mm/yyyy format select a.invctrlno as invctrlno, a.invno as InvoiceNumber, convert(varchar,a.invdt,103) as invdt,b.cname as cname from tblinvhd a,tblCstMst b where a.CCtrlNo =b.CCtrlNo order by invctrlno,invoicenumberi want to display dd/mm/yyyy format iam using vb.netDesikankannan |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-08-12 : 07:23:37
|
| 1 Dont worry how dates are stored in a table2 Always use proper DATETIME datatype to store dates3 Do formation at front end application, whenever you want to show there4 Use tostring("dd/MM/yyyy") in VB.netMadhivananFailing to plan is Planning to fail |
 |
|
|
|
|
|
date format issue