Important Code Samples
Friday, August 24, 2018
SQL Server Casting and Format commands
Select cast('9:30 AM' as time) -- <-- this convert the string into a Time
format ([First_call],'HH\:mm') --<-- This converts time into 24 hour clock format
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Postgress - Read a XML file from a postgress table XML column
SELECT xmltable.* FROM xmldata, XMLTABLE('//ROWS/ROW' PASSING data COLUMNS id int PATH ...
System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
if more than 65535 files in your temp folder, this error can occurs, To resolve this, remove all temporary files in C:/Windows/Temp ....
How to update first character upper case in Oracle
select upper(substr(CTY_CITY,1,1))|| substr(CTY_CITY,2,length(CTY_CITY)-1) as Ax from AGM_M_COUNTRY_CITY; update AGM_M_COUNTRY_CITY set ...
Sender Parameter/ Common functions (C#)
Common text box validation function for all the text boxes within the same form. Using Sender parameter to handle. private void tex...
No comments:
Post a Comment