Tutorialsteacher

Follow Us

Articles
  • C#
  • C# OOP
  • ASP.NET Core
  • ASP.NET MVC
  • LINQ
  • Inversion of Control (IoC)
  • Web API
  • JavaScript
  • TypeScript
  • jQuery
  • Angular 11
  • Node.js
  • D3.js
  • Sass
  • Python
  • Go lang
  • HTTPS (SSL)
  • Regex
  • SQL
  • SQL Server
  • PostgreSQL
  • MongoDB
  • SQL Server - Get Started
  • Install SQL Server
  • SQL Server Management Studio
  • SQL Server - Windows Authentication
  • SQL Server - Authentication
  • SQL Server - Create New User
  • SQL Server - GRANT/REVOKE Permissions to User
  • SQL Server - Data Types
  • SQL Server - Naming Conventions
  • SQL Server - CREATE Database
  • SQL Server - CREATE Table
  • Add Columns
  • Identity Column
  • Rename Column, Table
  • Drop Columns
  • SQL Server - Schema
  • SQL Server - Tables Relations
  • SQL Server - Primary Keys
  • Modify/Delete Primary Keys
  • SQL Server - Foreign Keys
  • Modify/Delete Foreign Keys
  • SQL Server - Check Constraints
  • SQL Server - Unique Constraints
  • SQL Server - Views
  • Modify/Delete Views
  • SQL Server - Functions
  • SQL Server - Stored Procedures
  • Stored Procedure Parameters
  • SQL Server - Indexes
  • Non-clustered Indexes
  • Modify/Delete Indexes
  • SQL Server - Triggers
  • DDL Triggers
  • LOGON Triggers
  • Enable/Disable Triggers
  • Modify/Delete Triggers
  • SQL Server - Sequence
  • SQL Server - Synonyms
  • SQL Server - IF ELSE Statement
  • SQL Server - Loops
  • SQL Server - Insert Data
  • SQL Server - Update Data
  • SQL Server - Delete Data
  • SQL Server - Select Query
  • WHERE Clause
  • GROUP BY Clause
  • HAVING Clause
  • ORDER BY Clause
  • SQL Server - Inner Join
  • Left Join
  • Right Join
  • Full Join
  • Self Join
  • Dynamic SQL
  • Built-in Functions
Entity Framework Extensions - Boost EF Core 9
  Bulk Insert
  Bulk Delete
  Bulk Update
  Bulk Merge

SQL Server CURRENT_TIMESTAMP() Function

In SQL Server, the CURRENT_TIMESTAMP() function returns the current system timestamp of the server on which the SQL Server database instance is installed. It is returned as a datetime value without the time zone offset.

Note: The CURRENT_TIMESTAMP() function is the ANSI equivalent to the GETDATE() function.

CURRENT_TIMESTAMP()

Parameters

No parameters.

Return Value

Returns current system timestamp of the server of datetime data type in YYYY-MM-DD hh:mm:ss.mmm format.

Note: You can use the CURRENT_TIMESTAMP function anywhere a DATETIME expression.

Get Current DateTime Stamp

In the following example, the CURRENT_TIMESTAMP() is used to get the current date and time value of the server hosting the SQL Server database instance.

Example:
SELECT CURRENT_TIMESTAMP AS CurrentServerDateTime;

Use Current_TimeStamp as Default Value

In the following example, the CURRENT_TIMESTAMP is used as a default value of a column.

Create a new table tblEmployeeLogin as shown below. This table captures the EmployeeId and the current date-time when an employee logs in. Here, the column EmpLogin takes the CURRENT_TIMESTAMP as its default value. It stores the timestamp as DateTime when an employee logs into the server.

Example: CURRENT_TIMESTAMP as Default Value of Column
CREATE TABLE tblEmployeeLogin
(
    id  INT IDENTITY, 
    EmployeeID 	INT NOT NULL, 
    EmpLogin    DATETIME NOT NULL 
                DEFAULT CURRENT_TIMESTAMP, 
    PRIMARY KEY(id)
);

Now, when an employee logs in then we will insert a new row into the tblEmployeeLogin table , as shown below. Assume that an employee with id 2 is logged in.

INSERT INTO tblEmployeeLogin(EmployeeID) VALUES(2);

Now, let's check the data. Select rows from the table and you will see that the EmpLogin column has the datetime stamp when the new row was inserted into the tblEmployeeLogin table.

Thus, the CURRENT_TIMESTAMP is used to get the current datetime value.

TUTORIALSTEACHER.COM

TutorialsTeacher.com is your authoritative source for comprehensive technologies tutorials, tailored to guide you through mastering various web and other technologies through a step-by-step approach.

Our content helps you to learn technologies easily and quickly for learners of all levels. By accessing this platform, you acknowledge that you have reviewed and consented to abide by our Terms of Use and Privacy Policy, designed to safeguard your experience and privacy rights.

[email protected]

ABOUT USTERMS OF USEPRIVACY POLICY
copywrite-symbol

2024 TutorialsTeacher.com. (v 1.2) All Rights Reserved.