Change the date of wordpress
Hi, wondering how I change the date wordpress thinks today is.. where does it pull the time and day from and is it possible to change that to say 2010 instead of 09 ...
datetime
Natural language dates in ruby/rails?
I need to show natural dates like "few seconds ago" "21 minutes ago" Is there something built in to the rails? Or may be third party? This is not hard to implement, but I do not want to invent the wheel. ...
Android java.util.Calendar - Time Difference
I want to make calendar view in order to support touch interaction. So I'd like to build new custom calendar view. I tried to make mapping function between view offset and real date value. Here is my idea: If I can compute the number of weeks since base date(in my case, 1989-12-31), it is easy to know offset. HEIGHT_FOR_WEEK * NUM_OF_W...
Define default date value in MySQL, similar to timestamp
I'm using MySQL (nobody's perfect), version 4.1 and I'm used to define some timestamp columns like that: ALTER TABLE foo ADD creation TIMESTAMP DEFAULT NOW() ; I'd like to do exactly the same thing, but for a DATE field. The reason being I don't need a TIMESTAMP precision and since no functional index exists in MySQL, I cannot access ...
How to loop between two dates
Hello! I have a calendar which passes selected dates as strings into a method. Inside this method, I want to generate a list of all the dates starting from the selected start date and ending with the selected end date, obviously including all of the dates inbetween, regardless of how many days are inbetween the selected start and end dat...
C# absolute min date
For political correctness, I would like to know if there is a way to instantiate a date so that it contains the lowest date value possible in c# net v2. ...
How does DateTime.ToUniversalTime() work?
How does the convertion to UTC from the standard DateTime format work? More specifically: if I create a DateTime object in one time zone and then switch to another time zone and run ToUniversalTime() on it, how does it know the conversion was done correctly and that the time is still accurately represented? Thanks ...
SQL statement help -- Select customers who ordered today
Say I have a table which stores customers order IDs. Such as | Customer ID | Order ID | Order Date How can I get all customers who have ordered today? Also OrderDate would be a DateTime. Something like SELECT DISTINCT CustomerID FROM TableName Where OrderDate > Today But the last part is what I can't figure out. ...
find-command: search with created time
How can I find things created "Jul 30 04:37" and move them to /tmp? Something wrong: find . -ctime "0037043007" -exec mv {} /tmp + ...
Axapta/DynamicsAx: UTC datetime conversion
We are trying to interpret the data stored in Axapata's TIMEZONESRULESDATA table. Particularly, we'd like to figure out how it stores DST begin/end times. So far, my guess is: TZENUM: foreign key referencing TIMEZONESLIST (time zone name and identifier) YEAR: 0 if rule is valid indefinitely or a year where the timezone rule is in effect...
how to use shell script checking last changed time of a file
I want to find if certain files are changed within the last three minutes in order to decide if the cp was successful, and if I should exit or continue the script. How can I do that? Thanks ...
MySQL / PHP: Date functions for page view statistics and popularity...
Hi, I have a table with number of page views per day. Something like this: +------+------------+------+ | id | date | hits | +------+------------+------+ | 4876 | 2009-07-14 | 4362 | +------+------------+------+ | 4876 | 2009-07-15 | 1324 | +------+------------+------+ | 7653 | 2009-06-09 | 5643 | +------+------------+------+ ...
How do I handle a DBNull DateTime field coming from the SQL Server?
I am getting this error when I retrieve a row with a null DataTime field: 'srRow.Closed_Date' threw an exception of type 'System.Data.StrongTypingException' How do I properly handle these? ...
How do I create a new Joda DateTime truncated to the last hour?
I am pulling timestamps from a file that I want to create a new DateTime for, but I want to create the DateTime at the floor of the hour (or any Joda Period will do). How Can I do this? ...
ComponentArt: Clear a cell in a grid if it is a certain DateTime.
Hi All, I currently have a ComponentArt Grid, which has a column containing DateTime values. In the even that a certain date is used, we want to keep the cell empty. Since DateTime is a struct it cannot be null or empty. So I am looking for a way to tell the grid to leave the cell blank if this certain date is bound to the grid. Any...
compute elapsed time in JavaScript
Hello everyone, I am looking for some JavaScript simple samples to compute elapsed time. My scenario is, for a specific point of execution in JavaScript code, I want to record a start time. And at another specific point of execution in JavaScript code, I want to record an end time. Then, I want to calculate the elapsed time in the form...
Comparing Date / DateTime ine Entity SQL Where clause...
I have a method which accepts an ObjectQuery and adds Where clauses to it depending on whether it receives values for various filter parameters. The method has to return an ObjectQuery. How can i do a basic Date comparison e.g. where dateX < dateY. This is my current code: if (myDateFilter != null) { query = query.Where( st...
Blackberry Java String to date conversion.
Hi, I used following code to convert string to date but it is applying timezone of device while conversion. I don't need this but I want same date/time from that string like String = "2009-07-31 07:59:17.427" Date = 2009-07-31 07:59:17.427 Date formatter = new Date(HttpDateParser.parse("2009-07-31 07:59:17.427")); SimpleDateFormat d...
Objective-C timespan
In C#, if I wanted to parse out a string into a date and timespan, I'd do something similar to the following: String input = "08:00"; DateTime time; if (!DateTime.TryParse(input, out time)) { // invalid input return; } TimeSpan timeSpan = new TimeSpan(time.Hour, time.Minute, time.Second); My Google-Fu has been less than desir...
Best method to input and validate custom datetime in PHP form
This is a double question in terms of front end usability and PHP DATE_TIME validation. I am working on a site for a client who would like to add the date he finished a project (so the projects can be listed in that order). He will be the only one using the admin interface, so I would like it to be as simple as possible. I am storing t...