Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am working to come up the learning curve
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.
You rock! Got it with the Floor!
You rock! Got it with the Floor!
Great, We are glad we were able to help
sql statement
CONVERT (varchar, table name, 103) as Date
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";