Free for PREMIUM members
Go Premium for a chance to win a PS4. Enter to Win
-- To create the columns
ALTER TABLE Travel
ADD Travel_Date date, Travel_Time time
-- To populate them based on your requirements
SET Travel_Date = CAST(ActualDateTime as date),
Travel_Time = CAST(ActualDateTime as time)
Open in new window
Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.
CAST(ActualDateTime as date) as Travel_Date,
CAST(ActualDateTime as time) as Travel_Time
CREATE TABLE Travel (ActualDateTime datetime)
INSERT INTO Travel (ActualDateTime)
VALUES ('2014-03-22 10:38:43.283'), ('2014-03-11 12:34:56.789'), ('2013-07-30 20:38:43.283')
convert(varchar, ActualDateTime ,5) as Travel_Date,
convert(varchar, ActualDateTime ,8) as Travel_Time
We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!