Assuming sunday is required, the following 13 results were found.
-
snippets for the various DSTs around the world. US (Except Arizona, Hawaii and US Territories?): DST Start Starts Second Sunday in March at 2:00 DST End Ends First Sunday in November at 2:00 // // Starts Second Sunday in March at 2:00 v_FirstMonthDate =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
the week ends on Friday. Assuming it starts on the previous Saturday. Why? Problems with MySQL weeks always starting on Sunday means this isn't very useful. I have another system which starts on Monday and ends on the following Sunday. The solution...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
A very quick article with a snippet of code to get today's date, tomorrow's, and the day after's but it has to skip Sundays. Why? Wanting to create a schedule for availability over the next few days which needs to dynamically change. I am aware of the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
A quick article on determining the week number of the year if your week starts on a Monday and not a Sunday. Why? I think it's the US system which generally says that a week starts on a Sunday but in the United Kingdom, the week generally starts on a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
17:00 Separator Marker Tuesday 11/10/2011 A001 08:00 17:00 NULL Tuesday 11/10/2011 A002 08:00 17:00 Separator Marker... Sunday 16/10/2011 A007 08:00 17:00 NULL Sunday 16/10/2011 A009 08:00 17:00 Separator Marker */ As I mentioned at the beginning of...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
17:15 7:45 29:15 2013-12-06 Friday 07:00 12:00 13:00 16:30 8:30 37:45 2013-12-07 Saturday - - - - 0:00 37:45 2013-12-08 Sunday 03:00 04:00 - - 4:00 41:45 Some Requirements; StartTime will be the earliest someone starts work that day. EndTime will be the...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
second array as follows: // lists Day_Names = List:String({"Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday"}); Day_Abbreviations = List:String({"Mon","Tue","Wed","Thu","Fri","Sat","Sun"}); // get date field day abbreviation...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
4 %j day of year, zero padded 001-366 %u day of week starting with Monday (1), i.e. mtwtfss 1 %w day of week starting with Sunday (0), i.e. smtwtfs 1 Week %U week number Sunday as first day of week 01–53 %W week number Monday as first day of week 01–53...
- Type: Article
- Author: Joel Lipman
- Category: Linux
- Language: *
-
003 1.00 1999-02-25 003 1.00 1999-02-26 -- note the dates increment and do not account for days off (eg. Saturday / Sunday) How? Adapted from a forum topic: SQLTeam Forums First of all, we want the rows to multiply based on the value of the column:...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
if(v_LastName.containsIgnoreCase("Lipman")) { // // get user id v_UserID = r_User.get("id"); // // startofweek is a sunday but we want to start counting from Monday 00:00 v_FirstDateOfWeek =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
AND YEARWEEK(s.DateTimeCreated)=YEARWEEK(NOW()) - $w_value AND s.StaffUserID='STRING_TO_REPLACE_PER_ITERATION' ) AS 'Sunday', ( SELECT SEC_TO_TIME(SUM(TIME_TO_SEC(s.EstimateTimeFinish)-TIME_TO_SEC(s.DateTimeCreated))) AS SecondsElapsed FROM...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
DATEADD(d, 6, calendar.StartDate)), 1, 3) + '-' + CAST(DATEPART(yyyy, DATEADD(d, 6, calendar.StartDate)) AS VARCHAR(4)) AS Sunday, DATEPART(wk, CAST(DATEPART(dd, DATEADD(d, 6, calendar.StartDate)) AS VARCHAR(2)) + '-' + SUBSTRING(DATENAME(mm, DATEADD(d,...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
more distractions. This is my filming of some Radio Controlled cars at the Torch Racing, UK event last Sunday. The FPV latency isn't good on this camera so it was no use here, so several challenges: No FPV: Keep the quadcopter pointed at the car. I...
- Type: Article
- Author: Joel Lipman
- Category: Quadcopters
- Language: *