Working with Date-Only and Time-Only data in SQL Server

home
database
view story

16 Kicks

Working with Date-Only and Time-Only data in SQL Server(weblogs.sqlteam.com)

submitted by jimrice14(880) 4 years, 8 months ago

It's all about using the right data types. Sure, there's no "date" or "time" only data type available, but that's no excuse to return VARCHAR strings formatted as dates or times instead of the correct data type: datetime.

1 comment |category: Database |Views: 5
Tweet

tags: Time Date SQL another

Everyones tags:

Your Tags:

Please login or signup.

Add a live kick counter to your blog >> liveImage

You can even customize the image by choosing your own colors, and then clicking the button below to update the preview and the html code:

"Kick It" text
"Kick It" background
kick count text
kick count background
border

Simply copy and paste this HTML into your blog post.

Users who kicked this story:

pmbrown(0) -

aspinator(0) -

spirit1(3160) -

ashithmr(90)

More who kicked this story...

Comments:

posted by gt1329a(7849) 4 years, 8 months ago 0

As someone who inherited an application that stores half its dates as datetime and half as identically formatted varchars, I think this should be required reading for anyone who wants to design a database schema.

Most Active Users

What's this?