I am trying to split my field "Shelving Date" in my "shelving" table into 2 separate fields called shelving date and shelving time. How would I write a query that can execute this? The shelving date and shelving time are separated by a space. Here is the format that the shelving date is in
I would like to separate it into shelving date = "2013-10-16" and shelving time = "08:55:55"