Type DateTime

  • Thread starter Thread starter Tony
  • Start date Start date
T

Tony

Hello!

If I want to store a date and time like this 2003-10-08 06:00:49 in the
database is then always the best choice to use type datetime
instead of using varchar.

//Tony
 
Hello!

If I want to store a date and time like this 2003-10-08 06:00:49 in the
database is then always the best choice to use type datetime
instead of using varchar.

//Tony
Click to expand...

Yep.. the data type is made for it.

..L.
 
Hello!

If I want to store a date and time like this 2003-10-08 06:00:49  in the
database is then always the best choice to use type datetime
instead of using varchar.

//Tony
Click to expand...

IS that a question?
if so the answer is yes, the varchar is only a representation of the
date,
Ask yourself this, what if you now want to display it like MM-DD-
YYYY ? if you have a DAteTime it's trivial, if you have a varchar you
have to parse the string and make the conversion.
 
If I want to store a date and time like this 2003-10-08 06:00:49 in the
database is then always the best choice to use type datetime
instead of using varchar.
Click to expand...

If by "like this" you meant "in this exact format," then you need to
understand that a date is a date is a date; it has no inherent format. A
format is merely a STRING REPRESENTATION of data and can be generated at any
time. You should always store values as values and worry about presentation
later. This means dates, numbers, and certain esoteric things like GUIDs
should always be stored in a native data type and formatted in your
presentation layer.

About the only exception I can think of off hand to "always store the raw
value" is if you were storing phone numbers for presentation. Then you might
really want to store 1-800-HOT-CHKS instead of 18004682427, but even then
you might consider making two columns, one for the raw value and one for the
formatted value.

If on the other hand you simply meant "with this level of precision," then
the answer would be yes, use a datetime (instead of a shortdatetime because
that's only accurate to the minute), but you would still want to use a date
data type and not varchar.
 
Tony said:
If I want to store a date and time like this 2003-10-08 06:00:49 in the
database is then always the best choice to use type datetime
instead of using varchar.
Click to expand...

Yes.

With VARCHAR you will sooner or later end up with a lot
of horrible string manipulation in your SQL, because
the functionality you need are not available for
VARCHAR.

You will have to write a lot of code to validate the
before being inserted. Or you will up with 2008-02-31 12:00:00
in the database.

Arne
 
You will have to write a lot of code to validate the
before being inserted. Or you will up with 2008-02-31 12:00:00
in the database.
Click to expand...

Ah, February 31st, 2008. What a great day that was....
 
Hello!

If I want to store a date and time like this 2003-10-08 06:00:49  in the
database is then always the best choice to use type datetime
instead of using varchar.

//Tony
Click to expand...

Hi Tony,
If you store a date as string, then you can not easily query the
stored values by date. Also it could happen, that reinterpreting the
date using DateTime.Parse won't work because of different culture. But
if you really must, then save and load dates to and from string
representations using invariant culture.

-- Henon
 
Back
Top