How can I truncate the time off my dates that are coming in the format 5/03/2016 12:00:00 AM

[#1]

I am working to come up the learning curve

[sunny_talwar]

I guess you are right, from the image it seems that the dates are read as date (and not text) because of their right orientation. A simple Date(Floor(DATE_CREAT)) as Date should work also.

[#3]

You rock!  Got it with the Floor!

[#4]

You rock!  Got it with the Floor!

[sunny_talwar]

Great, We are glad we were able to help

[#6]

sql statement

CONVERT (varchar, table name, 103) as Date

[#7]

rectifying

sql statement

CONVERT (varchar, column name, 103) as Date

SQL SELECT

"HOST_ORDER",

"ORDER_NUM",

"CUST_NUM",

"SHIP_TO",

CONVERT (varchar, DATE_CREAT, 103) as Date

    "DATE_CREAT",

    "DATE_ORDER",

    "DATE_CANCL",

    "DATE_REQD"

FROM "A1Warehouse"."dbo"."PICKHEAD";