Check SQL Server system Date and Time

Using below commands you can check SQL server date and time.

Open query browser and type the following commands. And when you execute it output will come out.

Command : 1

Select CURRENT_TIMESTAMP;

Command : 2

Select SYSDATETIME();

In below Results column its show the current Date and Time.

Current TIME in Various Formats

Below are the examples of current TIME in various formats:

1. Current TIME in the 24-hour format hh:mi:ss

SELECT CONVERT(VARCHAR(8), GETDATE(), 108) 'hh:mi:ss'

2. Current TIME in the 24-hour format hh:mi:ss:mmm

SELECT CONVERT(VARCHAR(12),GETDATE(),114) 'hh:mi:ss:mmm'

3. Current TIME in the 12-hour format hh:mi:ss:mmmAM

SELECT RIGHT(CONVERT(VARCHAR(26), GETDATE(), 109),14)

          'hh:mi:ss:mmmAM (or PM)'

Microsoft Excel Keyboard Shortcuts

Now, these days excel shortcuts is necessary for maintain day to day reports. So, we are sharing with you the basic excel shortcuts with you.

General Program Shortcuts

First, let’s take a look at some general keyboard shortcuts for manipulating workbooks

Open Excel using Run

Open Run > Type Excel then enter. It will open excel sheet.

Command's	Descriptions
Alt or F10	Turn key tips on or off
Alt+ F4	Close Excel
Alt+A	Go to the Data tab
Alt+Enter	Insert a hard return within a cell (while editing a cell)
Alt+F	Open the File tab menu
Alt+F1	Create an embedded bar chart based on select data (same sheet)
Alt+F11	Open the Microsoft Visual Basic For Applications Editor
Alt+F8	Create, run, edit, or delete a macro
Alt+H	Go to the Home tab
Alt+H+B	Add a border
Alt+H+D+C	Delete column
Alt+H+H	Select a fill color
Alt+M	Go to the Formulas tab
Alt+N	Open the Insert tab
Alt+P	Go to the Page Layout tab
Alt+Page Up/Down	Move one screen to the right or left in a worksheet
Alt+R	Go to the Review tab
Alt+W	Go to the View tab
Alt+X	Go to the Add-ins tab
Alt+Y	Go to the Help tab
Ctrl+0	Hide the selected columns
Ctrl+1	Open the Format Cells dialog box
Ctrl+5	Apply or remove strikethrough
Ctrl+9	Hide the selected rows
Ctrl+Alt+V	Open the Paste Special dialog box
Ctrl+B	Add or remove bold to the contents of a cell, selected data, or selected cell range
Ctrl+C or Ctrl+Insert	Copy contents of a cell, selected data, or selected cell range
Ctrl+End	Go to the most bottom right used cell
Ctrl+F	Search in a spreadsheet, or use Find and Replace
Ctrl+F1	Show or hide the ribbon
Ctrl+F11	Insert a new Excel Macro sheet
Ctrl+F2	Open Print Preview
Ctrl+F4	Close Excel sheet
Ctrl+F9	Minimize the workbook window
Ctrl+Home	Move to the beginning of a worksheet
Ctrl+I	Add or remove italics to the contents of a cell, selected data, or selected cell range
Ctrl+Left/Right Arrow	Move to the farthest cell left or right in the row
Ctrl+N	Create a new Excel
Ctrl+O	Open an older workbook
Ctrl+Page Up/Down	Move to the previous or next worksheet
Ctrl+S	Save Excel workbook
Ctrl+Shift+$	Apply currency format
Ctrl+Shift+%	Apply percent format
Ctrl+Shift+&	Apply outline border
Ctrl+Shift+_ (Underline)	Remove outline border
Ctrl+Shift+Space	Select the entire worksheet
Ctrl+Shift+U	Expand or collapse the formula bar
Ctrl+Space	Select the entire column
Ctrl+Tab	Switch between open workbooks
Ctrl+U	Add or remove underline to the contents of a cell, selected data, or selected cell range
Ctrl+Up/Down Arrow	Move to the top or bottom cell in the column
Ctrl+V or Shift+Insert	Paste contents of a cell, selected data, or selected cell range
Ctrl+W	Close a Excel sheet
Ctrl+X	Cut contents of a cell, selected data, or selected cell range
Ctrl+Y	Redo an action
Ctrl+Z	Undo an action
Delete	Remove the contents of a cell, selected data, or selected cell range
Enter	Complete an entry in a cell or the formula bar
Esc	Cancel an entry in a cell or the formula bar
F1	Open the Help page
F11	Create a bar chart based on selected data (on a separate sheet)
F12	Open the Save As dialog box
F2	Edit a cell
F3	Paste a cell name (if cells are named in the worksheet)
F5	Go to any cell by pressing F5 and typing the cell coordinate or cell name.
F7	Check spelling
F9	Calculate all worksheets in all Open workbooks
Home	Go to the leftmost cell in the current row (or go to the beginning of the cell if editing a cell)
Left/Right Arrow	Move one cell to the left or right
Page Up/Down	Move one screen up or down in a worksheet
Shift+F11	Insert a new Excel worksheet in existing Excel
Shift+F2	Add or edit a cell comment
Shift+F3	Insert a function
Shift+F9	Calculate active worksheets
Shift+Left/Right Arrow	Extend the cell selection to the left or right
Shift+Space	Select the entire row
Shift+Tab	Go to the previous cell
Tab	Go to the next cell
Up/Down Arrow	Move one cell up or down

Practice more make you learn quickly.