|
|
Posted by tlyczko on 06/12/27 11:58
Hello, I'm new to SQL Server, working for a non-profit computerizing a
lot of its data.
I imported a table of people's names, birth dates, etc. into SS2005
from Access, and the birth_date was imported as an Access date/time
field, giving it the datetime datatype in SQL.
The column values look like:
10/14/1964 12:00:00 AM
Where and how do I learn to specify that all fields like this should be
in ISO format of yyyy-mm-dd??
Do I have to create a new column and put all the dates into it??
Should I just convert the data in queries/views??
Use a constraint to format the data??
I can redo the Access table if necessary, it is only 300-some rows.
I tried BOL but it was not helpful...
The end users will likely enter mm/dd/yy or mm/dd/yyyy and it will have
to be stored properly in the database table as column/field
birth_date...
Thank you, Tom
Navigation:
[Reply to this message]
|