Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL
Expertise: Intermediate
May 2, 2006

Insert the Current Date/Time in a SQL Server, Excel Spreadsheet, or MSAccess

A quick way to insert the current date and time in an Excel spreadsheet, Access table, or SQL Server table is to use the following keyboard shortcuts:
  • Current date: CTRL+SEMICOLON
  • Current time: CTRL+SHIFT+ SEMICOLON
  • Current date and time: CTRL+ SEMICOLON then SPACE then CTRL+SHIFT+ SEMICOLON.
Srinath MS
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap