datetime

In .NET, to determine whether a supplied string is a date, which one is quicker: using DateTime to cast it to a date, or using a regular expression…

I have a table of records with a createddate in them. I would like to return the new records for each of the last 6 calendar months, including the…

I need to implement a rather complex query based on several date options in Zend / MySQL and would be glad to get some advice from people who are…

I have a MySQL query that runs via cron every 30 minutes to delete old property listings, the query is: DELETE FROM $wpdb->posts WHERE post_type…

I'm pulling from a datetime formatted field with mysql. I'm grabbing it with PHP, and I'm echoing it. I need to change the format so it is human…

I'm looking for a simple solution. Here is my date: 06/16/2011 22:12:10 But mysql expects: 2011-06-16 22:12:10 Alternatively is there something I…

for a basic SQL command via PHPMyAdmin in MySQL I want to select items more than 1 day old. I'm getting a basic error saying that there's a SQL…

I did a table in MySQL storing start and end times of working shifts in datetime type. I need to calculate two things from them (in MySQL). First of…

Is there a way to represent a time in ruby without having a Date attached? I am doing a timetracking application and I only need in/out times, there…

Within my CodeIgniter app, I'm using a Jquery calendar pop-up that also captures time as set by the user, so the end result looks like: MM-DD-YYYY…

How do request the date/time in PHP or MySQL within a timezone? I'd rather do it on the PHP side, but also would like to know if its possible in…

I have a script that is parsing out fields within email headers that represent dates and times. Some examples of these strings are as follows: Fri,…

Pretty much self-explanatory. Can MySQL sort dates (i.e. not alphabetically but like a date) when the dates have been formatted with DATE_FORMAT ?…

Let's say I have a datetime, June 16 2011 at 7:00. I want to be able to check at, say, August 5 2011 at 7:00 and be able to tell that it is exactly…

I have a table with column CreatedDate of data type datetime and i want to be able to set its default value to current DateTime how do i do it? I…

I have a sqlite database. I have three columns:_id, date, value. I now want to extract a count of the _id:s depending on the day in the date, and…

I have the following MySQL. SELECT `outputtable`.`date`, count(*) as `count` FROM ( SELECT CONCAT(DATE(`mytable`.`starttime`),'…

so right now I'm storing a the date of each search done on my site like this 2011-06-07 21:44:01 now I'd like to execute a query to select all…

The difference between to datetimes is the number of seconds between them. This seems to work only if the datetimes occur in the same hour. Why is…

I'm using a MySQL query to pull a range of datetimes as a Unix Timestamp (because I'll be converting them to Javascript time). I'm grouping by…