What?
This is an article on a trick I picked up from one of our interviewees as well as apparently in one of the Zoho documentation manuals. It uses leftpad to create a string of a length, converts ...
... is a function to multiply two ranges together (must be the same size) and return the total of these results.
-- is a double hyphen/dash which converts a boolean true to 1 and boolean false to 0.
IsNumber( ...
... converts Size (in bytes) to byte(s)/KB/MB/GB/TB (uses best option)
; decimalPlaces is the number of decimal places to round
; --------------------------------------------------------------------------------------
autoByteFormat(size, ...
... start with a function that just converts a string of words delimited by spaces to a table:
CREATE FUNCTION dbo.[ufn_StringToTable]
(
@StringInput VARCHAR(MAX)
)
RETURNS @OutputTable TABL ...
... conversion working in an SSIS package which read from a text file. Note that the example below converts a string in European Date Format (ie. "ddmmyyyy" to "dd/mm/yyyy"). Also, my data flow imports two ...
... converts it to a thumbnail. I then upload the images to my server and this Joomla! CMS uses them. Maybe I'll run this program again in a month, maybe a year. My websites don't depend on real-time screenshots ...
... ".$this_time;
Replace the variable names and the SQL column and table names as per your setup.
Converts 2001-06-25 09:41:00 to 25/06/2001 09:41:00
And Vice-Versa:
$posted_datetime=$_POST['this_datetime'];
$posted_datetime_array=explode(" ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.