t sql format date mm/dd/yy

Hi Krishna, try this. You should really have dates as a date type and not convert them to varchar. Note: Two dates can easily be compared if there is no time component involved! Examples might be simplified to improve reading and learning. Swindoll How to post questions to get better answers faster Managing Transaction Logs. By using format code 31 , we can convert the given datetime to yyyy-mm-dd format. Any help would be appreciated.

T SQL FORMAT DATE MM/DD/YY / morphy.info

• Secure and Private
• Easy to Use
• Find Matches Quickly
• Verified Profiles