MS Access Date Time
I have a date time filed in MS Access a database and woudl like to be able seperate in a query but so they keep the format settings. ie the date is a date and the time is still a time
Software/Hardware used:
Software/Hardware used:
ASKED:
February 8, 2008 11:10 AM
UPDATED:
February 8, 2008 7:53 PM
Answer Wiki:
Its ok i found i can do this by using the statement timevalue and datevalue.
Correct. You don't ever want to store formatting of the data in the database. Store just the value and deal with the formatting when the data is returned to the client application. This way if the formatting ever needs to change you don't have to modify all your data.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
