Assuming time is required, the following 223 results were found.
-
@NewVal varchar(max); DECLARE @OrigLen int; DECLARE @CurrLen int; DECLARE @LoopCt int; DECLARE @Rand int; -- for dates/times DECLARE @MinYear int; DECLARE @MaxYear int; DECLARE @RandYear int; DECLARE @RandMonth int; DECLARE @RandDay int; DECLARE...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
@OrigLen int; DECLARE @CurrLen int; DECLARE @LoopCt int; DECLARE @Rand int; DECLARE @RandString varchar(max); -- for dates/times DECLARE @MinYear int; DECLARE @MaxYear int; DECLARE @RandYear int; DECLARE @RandMonth int; DECLARE @RandDay int; DECLARE...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
note here just in case I need to refer to it again. Why? I want to modify a picklist and fill it with options from a certain time of the day to the closing time of the day (working hours). How? The plan is to iterate through a 24-hour clock, enable...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
ZohoCRM: Import Attachmentshttps://joellipman.com/articles/crm/zoho/zohocrm-import-attachments.html
who modified the attachment. Created By Id: This is a "zcrm_" prefixed ID of the user who created the attachment. Created Time: This is the created time of your file in the format that your CRM system is using (eg. "dd/MM/yyyy HH:mm:ss") Modified Time:...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
An article to document how I calculated the start and end dates of when Daylight Savings Time is in effect. Why? Admittedly, most of Zoho apps have this built-in but here's some snippets of code in case you need them. How? I will use this to amend and...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Just wanted a note to get in my head the logic if checking a requested time slot isn't a double-booking (as in, the time slot doesn't overlap a previous booking. How? Given a date/time and a duration, we will work out the requested start and end time:...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: en-GB
-
-- Ensure ID (primary key) match up on both systems unless you have -- custom usergroups. -- I did not have to do it this time but shout if you need help -- ********************************************************************** -- USERS: (but with...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
for each v_Day in l_DaysCorrectOrder { m_ShiftBuildUp.put(v_Day, m_ShiftRow); } // // ok let's get the opening times if(m_OrgDetails.get("custom_timing") != null) { l_CustomTimings = m_OrgDetails.get("custom_timing"); for each r_Timing in...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
GDPR Privacy Policyhttps://joellipman.com/static-items/gdpr-privacy-policy.html
your visit to JoelLipman.com. We reserve the right to make changes to our site, policies, and these Conditions of Use at any time. If any of these conditions shall be deemed invalid, void, or for any reason unenforceable, that condition shall be deemed...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
This is an issue relating to the Time Server Synchronization error. Basically you start up windows live messenger and get the following error: {rokbox title=|Messenger Error 80048820|}/images/screenshots/windows_live_error_80048820.png{/rokbox}...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: en-GB
-
2007 SP2...with ODBC to... MySQL v5+...hosting database... ActivityLog...contains activity, staffID, resourceID, start time, end time... Report Specification PivotTable Report...resources in row (along the side)......staff in columns (along the...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
Because I find a need to document anything that takes longer than 30 minutes to figure out so I don't spend so long the next time I have to do it. The use-case scenario here is that when an appointment is made for a Lead in a booking system, we want a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Privacy Policyhttps://joellipman.com/static-items/privacy-policy.html
be assured that it will only be used in accordance with this privacy statement. Joel Lipman .Com may change this policy from time to time by updating this page. You should check this page from time to time to ensure that you are happy with any changes....
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: en-GB
-
Unix Date Format Specifiershttps://joellipman.com/articles/linux/unix-date-format-specifiers.html
epoch) 1309785651 %S SS second 00–60 (The 60 is necessary to accommodate a leap second) %N nanoseconds 000000000–999999999 Time %r hours, minutes, seconds (12-hour clock) 01:20:51 PM %R hours, minutes (24 hour clock) hh:mm e.g. 13:20 %T hours, minutes,...
- Type: Article
- Author: Joel Lipman
- Category: Linux
- Language: *
-
The ReportServer Databasehttps://joellipman.com/articles/database/the-reportserver-database.html
I have just spent all morning on Microsoft websites to determine what number is the TimeDataRetrieval column displaying. Thank you I know it's an INT. There is just a serious lack of documentation as to what this database is and how it populates its...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
script.*/ using System; using System.Data; using Microsoft.SqlServer.Dts.Pipeline.Wrapper; using Microsoft.SqlServer.Dts.Runtime.Wrapper; using System.Globalization; // for cultureinfo and textinfo using System.Reflection; // for looping through...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
/XO -- /E makes Robocopy recursively 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. -- /XO excludes...
- Type: Article
- Author: Joel Lipman
- Category: MS-DOS
- Language: en-GB
-
and takes far too long, especially the part of adding the various field placeholders onto the template document; every time. What if I told you we can code a single button on the record which does all of that for you; with only you needing to approve...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
I understand and can customize to fit my needs. This PHP function accepts as parameter a SQL date (or date format that strtotime() can convert) and outputs the largest unit (for example "1 year" not "1 year 2 months 3 days, etc..."). function...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
tip or note to self: How to get yesterday's date irrespective of date format or daylight savings time. $today=date("Y-m-d"); $yesterday = date('Y-m-d', mktime(0, 0, 0, date("m") , date("d") - 1, date("Y")));
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF