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 |
In the rapidly evolving world of technology, efficiency is paramount. Despite being... read more
As Salesforce continues to dominate the Customer Relationship Management (CRM) space, the... read more
The "default" expression in C# is used to set a variable's default... read more
C# is an object-oriented programming language that provides a wide range of... read more
There is a basic structure in place that makes sure every website... read more
Two of the most well-liked solutions for a content management system (CMS)... read more
One of the most basic actions when working with relational databases is... read more
A junior developer asked me can I select some rows from a... read more
This article provides a high-level overview of the code review process for... read more
One fundamental concept within the realm of object-oriented programming (OOP) is polymorphism,... read more
Leave a Reply