Robby Dhillon djrobby

It seems that it does not matter what timezone is on the server as long as you have the time set right for the current timezone, know the timezone of the datetime columns that you store, and are aware of the issues with daylight savings time.

On the other hand if you have control of the timezones of the servers you work with then you can have everything set to UTC internally and never worry about timezones and DST.

Here are some notes I collected of how to work with timezones as a form of cheatsheet for myself and others which might influence what timezone the person will choose for his/her server and how he/she will store date and time.

	// Implementation in ES6
	function pagination(c, m) {
	var current = c,
	last = m,
	delta = 2,
	left = current - delta,
	right = current + delta + 1,
	range = [],
	rangeWithDots = [],
	l;

	#!/bin/sh

	#Check the Drive Space Used by Cached Files
	du -sh /var/cache/apt/archives

	#Clean all the log file
	#for logs in `find /var/log -type f`; do > $logs; done

	logs=`find /var/log -type f`
	for i in $logs

	<!DOCTYPE html>
	<html lang="es">
	<head>
	<meta charset="UTF-8">
	<title>Document</title>
	</head>
	<body>
	<style>
	#container {
	flex-shrink: 0;

	/*
	(c) by Thomas Konings
	Random Name Generator for Javascript
	*/

	function capFirst(string) {
	return string.charAt(0).toUpperCase() + string.slice(1);
	}

	function getRandomInt(min, max) {

	import sqlite3
	import os
	import argparse

	try:
	import pyspark
	import pyspark.sql
	except ImportError:
	import sys
	import os

	let state = [ "AK - Alaska",
	"AL - Alabama",
	"AR - Arkansas",
	"AS - American Samoa",
	"AZ - Arizona",
	"CA - California",
	"CO - Colorado",
	"CT - Connecticut",
	"DC - District of Columbia",
	"DE - Delaware",

	create schema shard_1;
	create sequence shard_1.global_id_sequence;

	CREATE OR REPLACE FUNCTION shard_1.id_generator(OUT result bigint) AS $$
	DECLARE
	our_epoch bigint := 1314220021721;
	seq_id bigint;
	now_millis bigint;
	-- the id of this DB shard, must be set for each
	-- schema shard you have - you could pass this as a parameter too

	#! /bin/bash
	# Description: show dependency tree
	# Author: damphat

	if [ $# -lt 1 ]; then
	echo 'Usage: apt-rdepends-tree [-r] <package>'
	echo 'Required packages: apt-rdepends'
	exit 1
	fi

	HTTP status code symbols for Rails

	Thanks to Cody Fauser for this list of HTTP responce codes and their Ruby on Rails symbol mappings.

	Status Code Symbol
	1xx Informational
	100 :continue
	101 :switching_protocols
	102 :processing

Robby Dhillon djrobby

MySQL Timezone Cheatsheet