Adding a TIME portion to a SQL DATE view
I have an ERP system that puts the date for all transactions with a time as 12:00:00 AM.
(example: 6/26/2017 12:00:00 AM)
I have a SQL VIEW that I am using to import data into another SQL database but the time needs to something other then that time because it conflicts with another import time. I want my time to be hardcoded as 23:59:00.00 PM instead of 12:00:00 AM.
SELECT ShippedDate AS ShipTransaction
FROM dbo.ShipmentOrder
My current result from above is:
6/21/2017 12:00:00 AM
My needed result for this line would be:
6/21/2017 23:59:00 PM
Note: I could also use converted date as 2017-06-12 23:59:00.000 (is date format of system I am importing into)
(example: 6/26/2017 12:00:00 AM)
I have a SQL VIEW that I am using to import data into another SQL database but the time needs to something other then that time because it conflicts with another import time. I want my time to be hardcoded as 23:59:00.00 PM instead of 12:00:00 AM.
SELECT ShippedDate AS ShipTransaction
FROM dbo.ShipmentOrder
My current result from above is:
6/21/2017 12:00:00 AM
My needed result for this line would be:
6/21/2017 23:59:00 PM
Note: I could also use converted date as 2017-06-12 23:59:00.000 (is date format of system I am importing into)
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
HainKurt
solutions provided should work for what is asked...