Let is say that we have the following Date 2007-04-05 10:13:14.109 and we want to get Year, Month and Day out of this date.
There is a function named DATEPART() that can be used to archive this.
DECLARE @MyDate AS DATETIME SET @MyDate = '2007-04-05 10:13:14.109' SELECT DATEPART(DAY, @MyDate) AS MyDay, DATEPART(MONTH, @MyDate) AS MyMonth, DATEPART(YEAR, @MyDate) AS MyYear
The result would be:
| MyYear | MyMonth | MyDay |
|---|---|---|
| 2007 | 04 | 05 |
C# is a popular programming language used for developing various types... read more
In the field of software development, each developer should work to... read more
Sometimes I want to use SqlDataSource returned data programmatically and here... read more
Ten years ago, Typescript was made available. Discover how a supportive... read more
Table of ContentsWhy Offline Website Optimization MattersStrategies for Offline Website Optimization1... read more
Table of ContentsIntroduction1. Communicate the Value2. Create a Learning Culture for... read more
C# is a powerful programming language that provides developers with a... read more
Here are a few deadly sins that you should avoid while... read more
The Google Play store is the most popular place for Android... read more
Writing clean code is an important skill for any software developer.... read more
Leave a Reply