» Home » dates » Page 1
Rails 3.1.8 strange timezone behaviour. subtracting dates.to_i gives zero, ruby says dates are different
Category : Coding

I'm upgrading from rails 3 to 3.1.8 (and onwards). A couple of my tests are failing, one of which seemed at first glance to be because of the change from mysql2 gem (0.2.x to 0.3.x). However, it gets a little stranger. Here's what's happening.

In my test I am updating attributes on a model, and checking that they've saved:

post :create, :advertisement =>

View Replies

How to group by week of the year dates or day dates that start on Sundays in oracle 10?
Category : Databases

Given a table:

day_date (form of yyyy-mm-dd)

I want to group the data by weeks, and the start of each week goes from Sunday to Saturday, but I want to display the day_date.

I have looked around all over, and I'm rusty on my SQL.


View Replies

Filter “between” certain dates with dates stored as text values
Category : Coding

I have SSRS Report with a text field MonthYear, containing values like "September 2012", "October 2012", etc.

I need to do a "between" filter, for example September 2012 - February 2013.

However, it seems to be imposible to do this any easy way, because this fields are in text format. I think that I have to convert this field to an integer format and then filter, but I

View Replies

Access Report Dates Display As Serial Dates in Excel 2003
Category : Computers
Access is database software well known for its ability to store, manipulate and report data. Because Access is part of the Microsoft Office suite, the reports created in Access can be exported to Excel. Date formatThe date format options in Access provide for a several date formats which can include the day, date or time or any combination of the three. The format can be specified in the table,

View Replies

Query to find records where a date is between start and end dates, where the dates might be reset to 0
Category : Databases

We have weekly recurring events in our application, and have decided to store the start and end times for each event as the number of seconds from the beginning of the week (Sunday 12am). This makes querying, sorting, etc. much easier.

However, there is one small problem: If we want to get the event that is happening at a time near the week reset, that event could bridge that gap, a

View Replies

NSDateFormatter returns wrong dates for older dates on iphones having Asia/Singapore timezones
Category : Programming Languages

I was building an application that will display a user's birthday.

The server is set to return unix timestamp.
The iPhone I am using is set to Singapore timezone.

For some users, their birthday can be displayed properly
But for some other users, the displayed birthday is one day earlier than the intended birthday.

I did a test and I notices that, fo

View Replies

how to highlight the previous dates and the next dates as compared to today's date in different colors in jquery datepicker?
Category : Programming Languages

i am using a jquery datepicker for showing the calendar in my code. i am using the beforeshowDay event to highlight selected dates. How can i assign different colors to the previous and next dates in this datepicker?

my beforeshowDay event calls the highlightDays fn as:

function highlightDays(date) {
for (var i = 0; i < new_date_array_1.length;

View Replies

MySQL JOIN to pull up latest posts by comparing post dates and comments dates
Category : Databases

Well, I have two tables community and community_comments.
community is the table where the topic title and other details of the topic is stored.
community_details is the table in which all the posts or comments for the topic/thread is stored.

I need to pull up the latest five topics based on the comments date for threads as well as date of the original topic/thread.

View Replies

i am using a pure javascript calendar for displaying the dates. i want to implement a swipe functionality to load the previous and the next dates
Category : Javascript

i am using a pure javascript function for displaying a calendar in a HTML5 page.
how can i implement a swipe functionality without using the hyperlinks.
a part of the code is:cal += 'previous year';

View Replies

Samus Mongodb-csharp Inserting Dates & Querying by Dates
Category : Coding

I am using the MongoDB-Csharp driver and I was wondering what the proper way to insert and query date field?

I tried using storing the dates using System.DateTime, but I am having issues when I try to query by date.


Inserting Data

var mongo = new Mongo();
var db = mongo.GetDatabase(dbName);
var collection = db.GetCollection(c

View Replies

2012 / 2017 Copyrights BigHow , All Rights Reserved .