Skip to main content

11. Date Functions

Image
By

The following table lists the most important built-in date functions in SQL Server:

Function
Description
GETDATE()
Returns the current date and time
DATEPART()
Returns a single part of a date/time
DATEADD()
Adds or subtracts a specified time
interval from a date
DATEDIFF()
Returns the time between two dates
CONVERT()
Displays date/time data in different formats

SQL Server comes with the following data types for storing a date or a date/time value in the database:
§ DATE - format YYYY-MM-DD
§ DATETIME - format: YYYY-MM-DD HH:MI:SS
§ SMALLDATETIME - format: YYYY-MM-DD HH:MI:SS

§ TIMESTAMP - format: a unique number








<<Prev                                                                                  Next>>








Labels:

Comments

Post a Comment

Popular posts from this blog

INDEX

By
                                                                                   INDEX      No.     Article                                                                       1.     Introduction of SQL           2.     Table Basic           3.     Keys and Constraints           4.     Referential integrity           5.     INDEX           6.     VIEW         ...
Post a Comment
Read more

14. Ordering Results

By
ORDER BY used to sort the result-set by one or more columns. It Sorts the records in ascending order by default. To sort the records in a descending order, you can use the DESC keyword. SELECT column_name , column_name FROM table_name ORDERBY column_name ASC | DESC , column_name ASC | DESC ; SELECT * FROM Customers ORDERBY Country DESC ;      <<Prev                                                                                      Next>>
Post a Comment
Read more

12. INSERT UPDATE and DELETE Queries

By
INSERT The INSERT INTO statement is used to insert new records in a table INSERTINTO table_name VALUES ( value1 , value2 , value3 ,...); Or INSERTINTO table_name ( column1 , column2 , column3 ,...) VALUES ( value1 , value2 , value3 ,...); UPDATE Used to update existing records in a table. UPDATE table_name SET column1 = value1 , column2 = value2 ,... WHERE some_column = some_value ; DELETE Used to delete rows in a table. DELETEFROM table_name WHERE some_column = some_value ; <<Prev                                                                           Next>>
Post a Comment
Read more