Home ›
ASP.NET Forums » Data Access » Data Access and ObjectDataSource Control » date format dd/mm/yyyy issues

date format dd/mm/yyyy issues

Last post 08-12-2008 8:54 AM by shadowcodes. 1 replies.

Sort Posts:

  • date format dd/mm/yyyy issues

    08-12-2008, 8:43 AM

    Hi,

    iam using sql 2005  its storing mm/dd/yyyy format but i want to display in the dd/mm/yyyy in the front end iam using

    vb.net 2005  i want to display below query in the gridview   and also in cyrstal report i want to show only date example 10/08/2008 but it show time also i dont

    want display time in cyrstal report   

    "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,invoicenumber"

    give some good suggestions about to display dd/mm/yyyy format , iam using datetime datatype ,looking forward your valuable suggestions

     

    Regards,
    Kannandesikan

  • Re: date format dd/mm/yyyy issues

    08-12-2008, 8:54 AM
    Answer
    • Member
      235 point Member
    • shadowcodes
    • Member since 08-01-2006, 2:26 PM
    • Sri lanka
    • Posts 113

     to format datetime datatype in sql itself use the below link

    http://www.blackwasp.co.uk/SQLDateTimeFormats.aspx

     

    or else if you want it to be done programmatically use the below link:

    http://en.csharp-online.net/CSharp_Format_Specifiers%E2%80%94DateTime_Format_Specifiers 

     

    hope it helps!!..

    regards,

    http://www.Aneef.net
Page 1 of 1 (2 items)
RSS Available

Contact | Advertise | Issue Management by Axosoft's OnTime | Running IIS7
All Rights Reserved. | Terms of Use | Trademarks | Privacy Statement
© 2009 Microsoft Corporation.