CODEWITHSUNDEEP
sql-server
Serenity
Serenity

Reputation: 5098

regarding ms sql data type

I got a column in which I wanna store date formats that is dd/mm/yy, mm/dd/yy , etc. What data type do I need to use for this column in my table ? DateTime??

oh and also if I want to store Time format like 24.00 hrs..What data type then ?

I need to store the FORMATS like mm/dd/yy or dd/mm/yy not dates like 2010-12-01 or whatever..SO I should use DATeTime only ?

Upvotes: 0

Views: 55

Answers (2)

ceth
ceth

Reputation: 45285

If you want to store date and time you need DateTime column type. To convert it to desired format you can use CAST and CONVERT functions.

To store formats as strings you can use VARCHAR - 'mm/dd/yy'.

Upvotes: 1

charliegriefer
charliegriefer

Reputation: 3382

Store the dates as datetime or timestamp or any of the built-in date or date/time datatypes. Don't worry about formatting the value in the db itself. You can format the date using the language of your choice (whatever language you're using to retrieve the information).

Upvotes: 1

Related Questions