none
date time format in query RRS feed

  • Question

  • Hi,

    I am using VS2005 and SQL Server 2000

    Now when I am using date time in VS 20005 i have to use

    Format(Me.dtp_FromDate.Value,"dd/MM/yyyy hh:mm tt")

    but I saw in other example they used "dd/MM/yyyy hh:mm AM/PM" format. so if I used this format then it show 18/06/2010 10:20 A5/P5 this value

    would you please help me without above format how can I use below format.

     

    Thursday, June 24, 2010 8:11 AM

Answers

  • hi Nerumon

    Please see this link , you will get answer

    http://www.sql-server-helper.com/tips/date-formats.aspx

     


    if the post helpful please mark it right else feel free to correct me
    • Marked as answer by Helen Zhou Thursday, July 1, 2010 1:37 AM
    Thursday, June 24, 2010 11:01 AM
  • Hi Nerurmon1,

    Please check C# DateTime Format Examples and Custom Date and Time Format Strings

    Sincerely,
    Helen Zhou


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    • Marked as answer by Helen Zhou Thursday, July 1, 2010 1:37 AM
    Tuesday, June 29, 2010 9:17 AM

All replies

  • hi Nerumon

    Please see this link , you will get answer

    http://www.sql-server-helper.com/tips/date-formats.aspx

     


    if the post helpful please mark it right else feel free to correct me
    • Marked as answer by Helen Zhou Thursday, July 1, 2010 1:37 AM
    Thursday, June 24, 2010 11:01 AM
  • Hi Nerurmon1,

    Please check C# DateTime Format Examples and Custom Date and Time Format Strings

    Sincerely,
    Helen Zhou


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    • Marked as answer by Helen Zhou Thursday, July 1, 2010 1:37 AM
    Tuesday, June 29, 2010 9:17 AM