Search - Joel Lipman .Com

1. Android Java: Remove first two entries from Google News feed in SimpleRssReader: / AndroidOS /; ... } holder.newsItemTitle.setText(items.get(position).getTitle()); holder.newsItemDateD.setText(items.get(position).getDate().substring(5, 7)); holder.newsItemDateM.setText(items.get(position).getDate().substring(8, ...; Created on 24 October 2014
2. SSIS Convert a string into a date: / SQL Server Integration Services /; ... NULL). -- PROBLEM: -- assuming date could be blank (has spaces) or in format DDMMYYYY (TRIM(Date) == "") ? (DT_DBTIMESTAMP)GETDATE() : (DT_DBTIMESTAMP)(SUBSTRING(Date,5,4) + "-" + SUBSTRING(Date,3,2) ...; Created on 14 March 2013
3. Cheat Sheet for mySQL vs t-SQL: / Databases /; ... DATENAME(dd, getdate()) Weekday Number DAYOFWEEK(now()) DATEPART(dw, getdate()) Month Name MONTHNAME(now()) DATENAME(mm, getdate()) Month Number MONTH(now()) DATEPART(mm, getdate()) European Date ...; Created on 31 January 2013
4. DataScramble - Randomizing data rows: / Transact-SQL /; ... -- SET YEAR RANGE (1912 - 1994: for Birthdate specifically: Older than 18 but younger than 100) SET @MinYear = DATEPART(YEAR,GETDATE())-100; -- 100 years ...; Created on 07 December 2012
5. Generate Academic Calendar using MySQL: / MySQL /; What? We have a specific timetabling system for academic institutions and all our staff/students follow academic week numbers as opposed to calendar week numbers. Why? The aim of this article ...; Created on 27 November 2012
6. DataJumble - Shuffling characters in a data value: / Transact-SQL /; ... -- SET YEAR RANGE (1912 - 1994: for Birthdate specifically: Older than 18 but younger than 100) SET @MinYear = DATEPART(YEAR,GETDATE())-100; -- 100 years ...; Created on 01 August 2012
7. T-SQL Record Separator: / Transact-SQL /; ... AS 'Site', wm.[WeekNumber] AS FacilityWeek, CONVERT(CHAR(10), GETDATE(), 103) AS 'WeekStart', CONVERT(CHAR(10), DATEADD(day, 6, GETDATE()), 103) AS 'WeekEnd', SD.[SetId] AS 'Set' FRO ...; Created on 11 October 2011
8. SQL Calendar in Business Intelligence Development Studio: / Transact-SQL /; ... @StartDate DATETIME, @EndDate DATETIME --First day of current month SET @StartDate = DATEADD(s,0,DATEADD(mm, DATEDIFF(m,0,GETDATE()),0)) --First day to display on calendar SET @StartDate = DATEADD(DAY,-DATEPART(WEEKDAY,@StartDate)+1,@StartDate) --Last ...; Created on 14 January 2011