我需要通过添加一个特定的 +/- GMT 值来操作一个通过 Mysql db 生成的日期时间, 或者从该时间 +/- GMT 时开始的第一个减 - 08: 00 。 例如, 现在我得到了这个数值捕捉到 2012 - 05 - 25 03: 04: 28 。 我需要第一个分钟 - 08: 00 然后 - 06: 00? 通过 php 实现这一点的最佳方式是什么?
您应该抢劫位于 DATETIME 类的 PHPs 。
//create new datetime instance
$dateTime = new DateTime("now", new DateTimeZone( Asia/Kolkata ));
echo $dateTime->format("Y-m-d H:i:s");
//add +1 day
$dateTime->modify("+1 day");
DateTime::add() - Adds an amount of days, months, years, hours, minutes and seconds to a DateTime object.
DateTime::sub() - Subtracts an amount of days, months, years, hours, minutes and seconds from a DateTime object.
Problem with using times in Python. Terminal > Python >>> calendar.timegm(datetime.datetime.now().utctimetuple()) 1258449380 This time indicates GMT: Tue, 17 Nov 2009 09:16:20 GMT Eclipse ...
I have a Windows service running (C#, .NET 2.0) on Windows Server 2003 R2. In one server the System.Threading.Thread.CurrentThread.CurrentCulture is {en-AU} and in the other {en-US}. This has caused a ...
I m writing a bit of logic that requires treating null dates as meaning forever in the future (the date in question is an expiration date, which may or may not exist). Instead of putting in special ...
Short Question: What s the best date format to use in SQL Server? Long Explanation: We re converting our database from mysql to SQL Server. In mysql we always used int(11) to avoid the daylight ...
Our current app stores all dates via the server s datetime. I m thinking we need to update all datetime values in the database over to UTC time. Now for displaying these dates back to the user, I ...
Is there any way I can easily check if a string conforms to the SortableDateTimePattern ("s"), or do I need to write a regular expression? I ve got a form where users can input a copyright date (as a ...
I m currently working on some DateTime properties in a PropertyGrid in c#.Net. Im using the default drop-down datetime picker. My question: Is there any way to show the full date with the time? By ...
I love the new DATE datatype in SQL Server 2008, but when I compare a DATE field to a DATETIME field on a linked server (SQL 2005, in this case), like this: DECLARE @MyDate DATE SET @MyDate = CONVERT(...