Easy way to strip time part in sql date time(cherupally.blogspot.com)

submitted by kcherupa(295) 2 years, 8 months ago

This explains the easy way to strip time part in sql date time read more...

3 comments |category: Database |Views: 289

tags: Date Database another

Automatically Update your Copyright Date(joelevi.com)

submitted by joelevi(50) 4 years, 4 months ago

If you’re like me you’ve got a whole slew of web pages that you’ve developed. That means you’ve got a lot of pages to modify every year to update the copyright to reflect the new year. Instead of hard-coding the year in to your xhtml, replace it with the following code snippet and you’re all set! read more...

add a comment |category: ASP.NET |Views: 9

tags: Date Year ASP.NET Copyright another

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. read more...

1 comment |category: Database |Views: 5

tags: Time Date SQL another

How to get the last day of the week(ivanuzunov.net)

submitted by kicheto(435) 4 years, 10 months ago

This sample shows how to get the last day of the current week. It easily could be reconfigured to get any day of the week of any date. read more...

add a comment |category: Tips & Tricks |Views: 20

tags: week Date another

SQL Server: How to store an incomplete date?(weblogs.sqlteam.com)

submitted by spirit1(3160) 5 years, 1 month ago

How to store an incomplete date in SQL Server? There are also some cool suggestions in the comments. read more...

add a comment |category: Database |Views: 19

tags: Date bitflag IncompleteDate Database SQLServer another