Assuming starttime is required, the following 11 results were found.
-
SQL basics are here to help me adapt it to whatever environment people keep throwing at me. What I want: ThisDate ThisDay StartTime TimeOut TimeIn EndTime TotalTimeToday TotalTimeWeek ----------- ----------- ---------- -------- ------- --------...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
= ifnull(input.ZohoProject_Project,0); v_IssueID = ifnull(input.ZohoProject_Issue,0); // // get data from form v_StartTime = ifnull(input.Start_Time.toTime(),zoho.currenttime); v_EndTime = ifnull(input.End_Time.toTime(),zoho.currenttime.addHour(1));...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Projects
- Language: *
-
just to do the below... hopefully it will be quicker next time now that I noted it all down. The SQL Script: DECLARE @StartTime datetime, @EndTime datetime, @GivenDate datetime; SET DATEFORMAT dmy; SET @GivenDate = '23/03/2011'; --First slot of the day...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
{ v_CheckDateStart = v_FirstMonthDate.addDay(v_DayIndex); if(v_CheckDateStart.toString("E")=="Sun") { v_DST_StartTime = v_CheckDateStart; } v_CheckDateEnd = v_LastMonthDate.addDay(v_DayIndex); if(v_CheckDateEnd.toString("E")=="Sun") { v_DST_EndTime =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
== "Subform1") { // loop through the first subform of this record for each r_SubformRow in r_Record.mySubform1 { v_StartTime = r_SubformRow.Start_Time; } } // set an else if condition else if(r_Record.Type == "Subform2") { // loop through the first...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
overlap a previous booking. How? Given a date/time and a duration, we will work out the requested start and end time: req_StartTime = input.Date_Field; req_Duration = 90; bool_doubleBooked=false; for each thisRecord in allRecords { thisRecord_StartTime...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
- 1, @baseDate) AS 'Date', datename(weekday, dateadd(d, tt.[WeekDay] - 1, @baseDate)) AS 'Day', tt.[SiteId] AS 'Site', tt.[StartTime] AS 'Start', tt.[FinishTime] AS 'Finish', tt.[RoomId] AS 'Room', sd.[Descrip] AS 'Event Type', sd.[Notes] AS 'Booking...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
for each v_WorkDay in m_ShiftBuildUp.keys() { info v_WorkDay; // // format the opening time and closing time v_StartTime = zoho.currenttime.toString("yyyy-MM-dd ") + m_ShiftBuildUp.get(v_WorkDay).get("open").leftpad(5).replaceAll(" ", "0") + ":00";...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
List(); l_OutputFields.add("BuyItNowPrice"); l_OutputFields.add("ItemID"); l_OutputFields.add("SKU"); l_OutputFields.add("StartTime"); l_OutputFields.add("TotalNumberOfPages"); l_OutputFields.add("TotalNumberOfEntries");...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
l_OutputFields.add("QuantityAvailable"); l_OutputFields.add("SellingStatus"); l_OutputFields.add("StartTime"); l_OutputFields.add("TotalNumberOfPages"); l_OutputFields.add("TotalNumberOfEntries"); m_Params.put("OutputSelector",l_OutputFields); // // now...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
[pretendDatabase].[pretendSchema].[WEEKSTRUCTURE] WHERE WeekNumber=wm.[WeekNumber])) AS 'Date', tt.[RoomId] AS 'Room', tt.[StartTime] AS 'Start', tt.[FinishTime] AS 'Finish', sd.[Descrip] AS 'Event Type', sd.[Notes] AS 'Booking Notes', c.[Name] AS...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB