Newsgroups: php.internals Path: news.php.net Xref: news.php.net php.internals:42212 Return-Path: Mailing-List: contact internals-help@lists.php.net; run by ezmlm Delivered-To: mailing list internals@lists.php.net Received: (qmail 91065 invoked from network); 10 Dec 2008 10:25:19 -0000 Received: from unknown (HELO lists.php.net) (127.0.0.1) by localhost with SMTP; 10 Dec 2008 10:25:19 -0000 Authentication-Results: pb1.pair.com smtp.mail=pstradomski@gmail.com; spf=pass; sender-id=pass Authentication-Results: pb1.pair.com header.from=pstradomski@gmail.com; sender-id=pass; domainkeys=bad Received-SPF: pass (pb1.pair.com: domain gmail.com designates 72.14.220.157 as permitted sender) DomainKey-Status: bad X-DomainKeys: Ecelerity dk_validate implementing draft-delany-domainkeys-base-01 X-PHP-List-Original-Sender: pstradomski@gmail.com X-Host-Fingerprint: 72.14.220.157 fg-out-1718.google.com Received: from [72.14.220.157] ([72.14.220.157:13339] helo=fg-out-1718.google.com) by pb1.pair.com (ecelerity 2.1.1.9-wez r(12769M)) with ESMTP id 33/F2-11210-C099F394 for ; Wed, 10 Dec 2008 05:25:17 -0500 Received: by fg-out-1718.google.com with SMTP id 16so182655fgg.23 for ; Wed, 10 Dec 2008 02:25:14 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:from:reply-to:to:subject:date :user-agent:cc:references:in-reply-to:mime-version:content-type :content-transfer-encoding:content-disposition:message-id; bh=jFWreg/JdQAfYWzVL2dtk1XypZ7iJiMT1M4ePwFqXrU=; b=ok9XUpdabGFM+5czHvveMYGP8YnDg+KIF9R1Kd3aPGxwUrKnyhuJ17hTwVkEhb/mnD 8I3a/GwZy2YMVVjVPLX+jEnnHMspZirvfGY6TB7FN96cWSeRjON0hh61We6V4sbWwP9y qvutawLPSpJ2pvG4p8RGEJ0FMvesNaW1Z/gUM= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=from:reply-to:to:subject:date:user-agent:cc:references:in-reply-to :mime-version:content-type:content-transfer-encoding :content-disposition:message-id; b=PXpscdxurgAUUBPLGfjiyVNn+J+V82K6UsmvA8Rnuv0XfThyWNcaouJc7se7N81Oze OWo2U2Uz3y5Ml3sTQq4M7NmNlZe3i/eTuM9hKFAkAD8dmmxNAHB9AEq3yPInjvbK6SfI 5Eh1GnCc7hu2qKepanCZK7s+2GJL8TiaDHoQI= Received: by 10.86.72.3 with SMTP id u3mr611526fga.1.1228904714134; Wed, 10 Dec 2008 02:25:14 -0800 (PST) Received: from ?192.168.13.111? (hep138.internetdsl.tpnet.pl [79.187.119.138]) by mx.google.com with ESMTPS id 4sm1298665fgg.42.2008.12.10.02.25.09 (version=TLSv1/SSLv3 cipher=RC4-MD5); Wed, 10 Dec 2008 02:25:12 -0800 (PST) Reply-To: =?utf-8?q?Pawe=C5=82_Stradomski?= To: internals@lists.php.net Date: Wed, 10 Dec 2008 11:27:18 +0100 User-Agent: KMail/1.9.9 Cc: "Jonathan Bond-Caron" , "'Lester Caine'" References: <4938C8FB.6010509@lsces.co.uk> <493A08F3.6090500@lsces.co.uk> <004901c95a1a$d3e3c8e0$7bab5aa0$@com> In-Reply-To: <004901c95a1a$d3e3c8e0$7bab5aa0$@com> MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-ID: <200812101127.19044.pstradomski@gmail.com> Subject: Re: [PHP-DEV] Upgrading to internal DateTime From: pstradomski@gmail.com (=?utf-8?q?Pawe=C5=82_Stradomski?=) W li=C5=9Bcie Jonathan Bond-Caron z dnia wtorek 09 grudnia 2008: > Unix timestamps are simpler since you know they are always in UTC. > > Just thought I'd raise that there's nothing wrong with storing all dates = as > ISO in a given timezone. It takes a little more work but if your > consistent, it can managed. > > If I'm wrong, please let me know :) It's not really feasible to store dates in specific timezone, as most=20 national/local timezones support DST - and that is a pain to support, as eg= =2E=20 sorting breaks when some timestamps get repeated. That's why it's usually=20 better to store datetimes as either UTC datetime or plain unix timestamp. I= =20 usually go with the former - using database datetime type. =2D-=20 Pawe=C5=82 Stradomski