Get AM/PM in Sql Server DateTime Format
Sql Server natively does not provide any convert format to get AM/PM part from DateTime datatype.
The following T-SQL snippet gets the AM/PM from a DateTime format in Sql Server.
print Right(CONVERT(VARCHAR,getdate(),9),2)
Leave a reply
Related Posts
- Schedule Sql Server Job to run every 30 Seconds
- T-SQL to find Procedures/Commands used in Sql Server Jobs
- Selecting Random Rows from a Table in SQL Server
- Useful SQL Server Management Studio Keyboard Shortcuts
- Case-sensitive check/search/match in T-SQL - Sql Server 2005
- Replace/Remove Special Characters in Sql Server 2005/2008
- Create Linked Server in Sql Server 2005
- Alter/Change new Default Value of a Column in already created Table
- T-SQL to Disable/Enable Job in SQL Server 2005
- Invoke URL from Sql Server 2005 Stored Procedure
- T-SQL to change schema/owner name in Sql Server
- Delete Statement with inner join in Sql Server 2005
- Transpose Rows to Columns in Sql Server 2005 using PIVOT
- Transpose Columns to Rows in Sql Server 2005 using UNPIVOT
- Split Function in Sql Server to break Comma-Separated Strings into Table
- Delete duplicate rows on table with/without primary key in Sql Server 2005
- Sql server: Special Characters (%,[,]) in LIKE operator using ESCAPE keyword
- Pagination in Sql Server 2005
- Transact-SQL to get description of column in Sql Server 2005 using fn_listextendedproperty
- SQL to Grant EXECUTE permission to all Procedures and Functions
- Search text/string|Find keyword in Sql Server Function and Procedure
- Title case (Proper case) Function in Sql Server 2005
- Cursor For Converting Rows to Column in Sql Server
- Changes Row to Columns (Transpose) in Sql Server 2005 using COALESCE
Do you like this post?
