Search - Joel Lipman .Com

1. Zoho Deluge: Calculate Days, Hours, Minutes, Seconds between two Timestamps: / Zoho /; What? A very quick article to calculate the time between two timestamps and break it down into days, hours, minutes and seconds. Why? I've done this in lots of other systems but here's one in Zoho ...; Created on 21 September 2021
2. Zoho Deluge: Convert Xero Date (Unix Timestamp) to Standard Date String: / Zoho /; ... Zoho CRM Invoices and noticed that Xero stores its dates in Unix Timestamps. How? We're going to filter out the unix seconds from the date provided by Xero then apply a toTime() function to it. v_XeroTime="/Date(1586995200000+0000)/"; v_StartIndex ...; Created on 04 May 2020
3. T-SQL DateTimestamps: / Transact-SQL /; ... CURRENT_TIMESTAMP, 0) Oct 11 2011 6:00AM CONVERT(CHAR(8), CURRENT_TIMESTAMP, 1) 10/11/11 CONVERT(CHAR(8), CURRENT_TIMESTAMP, 2) 11.10.11 CONVERT(CHAR(8), CURRENT_TIMESTAMP, 3) 11/10/11 CONVERT(CHAR(8), ...; Created on 23 March 2011
4. Zoho Workdrive: Getting Team Folder ID: / Zoho /; ... a timestamped duplicate if exists so need to check if it exists first) // https://workdrive.zoho.com/home//teams//ws//folders/files m_SubfolderNames = Map(); r_Subfolders = invokeurl [ url :"https://www.zohoapis.com/workdrive/api/v1/teamfolders//folders?page%5Blimit%5D=50&page%5Boffset%5D=0" type ...; Created on 11 September 2024
5. Zoho Creator / eBay: Get all Active Products: / Zoho /; What? This is an article to document a function used in Zoho Creator to retrieve the Product IDs of all the active products in a client's eBay store. Why? The use-case was that I wanted to retrieve ...; Created on 13 October 2021
6. Zoho Creator: Receive eBay Order Notifications via Webhook: / Zoho /; What? This is an article to document how I got a client's eBay to notify the seller every time a buyer bought a fixed price item. This uses the Trading API even though I'm aiming for the Platform Notifications ...; Created on 20 September 2021
7. Google Drive API v3 - OAuth2 using Service Account in PHP/JWT: / Google /; ... to generate the infamous JWT. If you've been trying to check your base64 encoded strings at JWT.io then it's hard because the timestamps, included in the encoding, change every second. You can get it verifying ...; Created on 02 February 2019
8. Google Authentication - OAuth 2.0 using PHP/cURL: / Google /; ... on the code. How? So the plan is: Declare the functions. Authenticate on page load by checking timestamp in token file: If token is required, redirect user to Consent page and rewrite token ...; Created on 31 October 2018
9. Accessing Apimo WebService API: / API Miscellaneous /; ... IDs to match your own solution): // specify provider ID $my_provider_id = 1234; $my_timestamp = time(); // specify company ID $company_id_1 = 1234; $company_id_2 = 4321; // specify agency ...; Created on 29 March 2016
10. MS-DOS: Copy folders without overwriting files: / MS-DOS /; ... copy subdirectories, including empty ones. -- /XC excludes existing files with the same timestamp, but different file sizes. -- /XN excludes existing files newer than the copy in the source directory. -- ...; Created on 23 February 2014
11. SSIS Convert a string into a date: / SQL Server Integration Services /; ... (YYYYMMDD) (DT_DATE)(SUBSTRING(This_Date,6,2) + "/" + SUBSTRING(This_Date,9,2) + "/" + SUBSTRING(This_Date,1,4)) -- Assuming [This_Date]="21032012" (DDMMYYYY) (TRIM(This_Date)=="")? (DT_DBTIMESTAMP)"1901-01-01 ...; Created on 14 March 2013
12. Live WebCam feed of Bournemouth: / Web-Development /; So having moved desk from one side of the room to another, I have lost my view of the sea. Oh well, this is where technology has come to the rescue and returned my calming view... Note: I think this ...; Created on 30 January 2013
13. Data Randomization Function in Oracle PL/SQL: / Oracle PL/SQL /; ... 'DATE') random_date, -- testing date UFN_DATASCRAMBLE(TO_DATE('2012-01-01 05:31:18','YYYY-MM-DD HH24:MI:SS'), 'DATE') random_timestamp, -- testing timestamp UFN_DATASCRAMBLE(TO_DATE('2012-01-01','yyyy-mm-dd') ...; Created on 22 August 2012
14. MediaWiki: MySQL to extract path to images: / MediaWiki /; ... name, size, user who uploaded, timestamp and the path. Remember that the paths are determined using the MD5 Hash of the filename: select img_name, img_size, img_user_text, img_timestamp, CONCAT(SUBSTR(MD5(img_name), ...; Created on 06 December 2011
15. Performance Report - Background colors based on dataset values: / SQL Server Reporting Services /; ... work on your reporting server as well. I'm using the database "ReportServer". select * from ( SELECT TOP 1 c.[Name] AS [ReportName] , e.[ReportID] AS [ReportID] , e.[TimeStart] AS [TimeStamp] , ...; Created on 02 December 2011
16. How to Display Report Execution Time in SSRS (milliseconds): / SQL Server Reporting Services /; ... milliseconds it took for a report to execute... I decided to do a database level calculation using two datasets: -- Oracle 10g: DataSet1 -- your normal dataset query with an added field (ReportStartTime) SELECT field1, field2, TO_CHAR(systimestamp, ...; Created on 17 November 2011
17. SSRS Retrieving Oracle Stored Procedure Success or ErrorLevel: / SQL Server Reporting Services /; ... that there appears a link that will run a stored procedure which Updates a timestamp in an existing table Inserts a row into an audit table I need the report to run the stored procedure, then ...; Created on 04 November 2011
18. T-SQL Record Separator: / Transact-SQL /; ... row. My final query This displays all room bookings for today and the next 6 days. Note how I can't use normal dates because the database wasn't designed with timestamps (despite being a timetabling ...; Created on 11 October 2011
19. Difference between two dates - the midnight hour: / Web-Development /; ... to... Compare the two timestamps, if the "To date" is less than the "From date" then add 1 day to the date: $thisDateSQL=date("Y-m-d", strtotime($sub_row['DateSession'])); $this_time_from1 = date("H:i ...; Created on 06 April 2011
20. Formatting a date in an MDX query: / Transact-SQL /; ... is about formatting dates and times but if you want a NOW timestamp in a specific format, try... =Format(now(), "ddd, dd MMMM yyyy HH:mm:ss") =Format(now(), "dd/MM/yyyy") The reserved expression ...; Created on 11 January 2011