SQL Convert Date not working

Posted on 2012-09-11
Last Modified: 2012-09-11
I'm having an issue with converting a date from YYYY-MM-DD to DD/MM/YYYY. When I put CONVERT(date,sh.Order_Date,101), it still comes back as YYYY-MM-DD. I tried changing the style to 102, 103, 104, 105, etc. and it keeps returning the same format each time. The data type for OrderDate is datetime, so I'm not sure what the issue is. I even tried convert(date,cast(OrderDate as date),101) and got the same result. Can someone help me?
Question by:FVIAH
    1 Comment
    LVL 15

    Accepted Solution


    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Join & Write a Comment

    Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
    Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
    Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
    Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

    731 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now