Assuming convert is required, the following 94 results were found.
-
before the end) SET @EndTime = @GivenDate + ' 17:30:00'; ; WITH Times([Time]) AS ( --Select First hour in range SELECT CONVERT(DATETIME,@StartTime) AS [Time] UNION ALL --Add a record for every half-hour in the range (change based on slot times) SELECT...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
A very quick article on converting a Map string into a HTML table without using a for each loop. Why? I have quite a big response from our CRM that hits a statement execution limit if I use a for loop. I have a map with 3 columns: first_name, last_name,...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
and I thought I'd note them on my site so I can refer to them more easily. How? Let's 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) )...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
What? A quick article showing my MySQL statement when I want to remove all the accents from foreign characters and return the English equivalent. Why? A content management system (CMS) that I'm working on has just gone international and started...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
These are for autohotkey and in AHK code. Taken from Autohotkey forums topic 1878: From Hexadecimal to RGB From RGB to Hexadecimal Check for a valid hexadecimal value From Hexadecimal to RGB: HEX2RGB(HEXString,Delimiter="") { If Delimiter= Delimiter=,...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
Just a quick note as to something that worked for me. Taken from the Oracle forums @ https://forums.oracle.com/forums/thread.jspa?messageID=6861756 Situation I have one column of values that I've suffixed a comma to but I want to display this as a rows...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
What? Just a quick note on how to format a given filesize and to reduce the display output to a small string, eg: 196 bytes : displays as => "196 bytes" 12945 bytes : displays as => "12 Kb" 1478515 bytes : displays as => "1 Mb" 8798745455 bytes :...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
// optional m_Data= Map(); m_Data.put("data",m_RecordData.toJSONList()); // NOTE: convert this to a JSON Array r_RecordUpdate = invokeUrl [ url :v_EndPoint type :PUT headers: m_Header parameters:m_Data.toString() ]; // NOTE: convert parameters variable...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
a function I use called "Filexpro()", then list some examples of usage. And in the second-to-last section, I'll quickly convert a 100 nanoseconds unit to display Hours : Minutes : Seconds. We could have tried out some cool new DLL files for MS Windows...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
If you need to remove files which are simply the converted versions of music or video files, then this tool asks which folder has the files it will keep and which ones it will send to the Recycle Bin. TESTED ON: - Windows XP, Windows 7 SCREENSHOTS:...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
m_Params.put("PreferenceLevel","User"); m_Params.put("WarningLevel","High"); m_Params.put("ErrorLanguage","en_GB"); // // convert to xml and replace root nodes x_Params = m_Params.toXML(); x_Params = x_Params.toString().replaceFirst("",""); x_Params =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
AS ReportName , MIN(ExecutionLogStorage.TimeStart) AS [First] , MAX(ExecutionLogStorage.TimeStart) AS [Last] , CAST(CONVERT(CHAR, DATEADD(millisecond, MAX(DATEDIFF(MILLISECOND, ExecutionLogStorage.TimeStart, ExecutionLogStorage.TimeEnd)), '00:00:00'),...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
you can tell these are my messed up functions that convert dates into seconds and vice-versa. They're a little disorganised but they're the ones I copy and paste to my scripts then modify. In it's straightforward form FormatTime( TimeString, Format ) {...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
for FREE. I don't get it. So I wrote a program that does exactly that: visits each website in a list, takes a picture, 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...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
to generate a 5 letter code from several functions: one which returns 5 randomly selected characters and another two which convert a number to 5 letters. Why? Zoho doesn't have a function to generate random numbers or strings. There are workarounds...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
day so we add 1 business day) v_NextTime = zoho.currentdate.addBusinessDay(1).toString("yyyy-MM-dd ") + "12:00:00"; // // convert to seconds v_NowEpoch = v_NowTime.toLong(); v_NextEpoch = v_NextTime.toTime().toLong(); // // calculate seconds in between...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
AS VARCHAR(10)), 2, 1000) AS Items FROM Employees_Attendance_Table JOIN master..spt_values n ON n.type = 'P' AND n.number...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
through subform rows and check if column "Skill" has unique values for (var i = 0; i...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
]; l_PastEvents = ifnull(r_PastEvents.get("events"),List()); for each m_PastEvent in l_PastEvents { // // convert a Zoho Project DateTime to a DateTime datatype (given 12/12/2023 12:00:00 PM... remove ambiguity: mm/dd or dd/mm?)...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Projects
- Language: *
-
from a related quote, it maps in the fields. Why? The process should be that you go to the CRM quote record and click on "Convert" > then select "Invoice", and it should map the fields over. Great! But what if someone skips the process, in other words,...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *