Change Regional Settings for your Reporthttps://joellipman.com/articles/microsoft/ssrs/change-regional-settings-for-your-report.html

17 May 2010 Basically I thought that the regional settings of a report generated using Report Builder 2.0 on a MS SQL Server 2008 instance were dependent on either the server or the client machine. Realised that this was actually specified in the report. Here's a...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

Parameters not being used in report processinghttps://joellipman.com/articles/microsoft/ssrs/parameters-not-being-used-in-report-processing.html

07 January 2011 ASC Importantly, note the following: SET DATEFORMAT dmy returns the date in European format irrespective of the regional settings of either the client or the reporting server. Removed @GivenDate datetime, from the SQL script Removed @GivenCampus...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

T-SQL DateTimestampshttps://joellipman.com/articles/database/t-sql/t-sql-datetimestamps.html

23 March 2011 setup Windows XP SP3 MS SQL Server Management Studio 2008 SQL Server 2008 R2 Regional Setting: London BST (British Summer Time) Tuesday the 11th of October 2011 at 06:00am: CONVERT(CHAR(19), CURRENT_TIMESTAMP, 0) Oct 11 2011 6:00AM CONVERT(CHAR(8),...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: en-GB

Run commands for Windowshttps://joellipman.com/articles/microsoft/windows-os/run-commands-for-windows.html

05 July 2011 Quicktime (If Installed) QuickTime.cpl Quicktime Player (if installed) quicktimeplayer Real Player (if installed) realplay Regional Settings intl.cpl Registry Editor regedit Registry Editor regedit32 Remote Access Phonebook rasphone Remote Desktop mstsc...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: en-GB

Convert seconds to total time in PHPhttps://joellipman.com/articles/web-development/php/convert-seconds-to-total-time-in-php.html

31 January 2012 This is the shortest way I know to properly convert seconds into total hours, minutes and seconds (taking into account regional settings and without using a date function). How? $total_time =intval(intval($total_seconds)/ 3600).":";...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB