Tagged Questions

DateTime objects in many programming languages describe an instant in time, expressed as a date and time of day.

learn more… | top users | synonyms (1)

0
votes
0answers
9 views

mysql select all calculate difference bewteen multiple rows to on result from pivot

I have an pivot table from an root table here on SQL Fiddle, this link: pivot operation Here I try to calculate the difference between "Arbeitszeit", "Arbeitsende" and between "Projektzeit" and ...
0
votes
1answer
12 views

How to convert a struct tm to DateTime in c++/cli

I have a variable in c++/CLI whch holds time as a struct tm. I need to convert it to managed DateTime. How can I do this? struct tm t=GetTime(); DateTime time= ConvertToDateTime(t); In the above ...
1
vote
2answers
12 views

mysql add column for hour difference between 2 dates

I have edited a mysql table here in SQLfiddle: enter link description here As you can see there, i would like to add a column for calculating the difference bewtween the time column and NOW() in ...
2
votes
1answer
38 views

How do I parse an RFC822 date in .NET?

I have the following datetime string as returned to me by the Twitter API: "Thu Apr 26 11:38:36 +0000 2012" I need to convert this to a DateTime object so I call ParseExact with a custom format ...
0
votes
1answer
17 views

Programmatically check if iPhone clock is synched

Is there anyway to check if the iPhone clock is internet synched or if it is manually set from my program? I need to verify if the user is changing the clock.
0
votes
3answers
29 views

Calendar.getTime() not returning UTC date if TimeZone is defined

I have did this for my Calendar instance to return Date in UTC timezone SimpleDateFormat formatter = new SimpleDateFormat("dd-MM-yyyy HH:mm:SS Z"); TimeZone tz = ...
0
votes
2answers
26 views

Insert datetime to database

Date currentDateTime; java.sql.Date sql_currentDateTime; currentDateTime = getCurrentDateTime(); //Fri Jun 21 15:53:59 AZST 2013 sql_currentDateTime = new java.sql.Date(currentDateTime.getTime()); ...
-5
votes
3answers
43 views

How to get difference between two dates and time?

I am working on Quiz App. In my app I want to get difference between quiz start time and end time. How to get difference between start and end time. Thanks in advance.
-1
votes
4answers
74 views

What is the best way to save datetime type in SQLite? [closed]

Okay i'm creating android apps and need to save date/time of the creation record. so what is the best way to do that ? because i need to compare it later. in my apps i will show all record are created ...
0
votes
0answers
6 views

`baseline` option for date values does not work in Google Visualization

I am trying to draw a baseline on a chart that uses date values to chart. Here is the code, and here is what the chart looks like: function drawVisualization() { // Create and populate the data ...
0
votes
3answers
49 views

Calculate maximum number of open events

I have a list of events with an open and close date, like this: DateOpen | DateClose -----------|----------- 01.01.2000 | 05.01.2000 02.01.2000 | 02.01.2000 So on the 01.01. we have one open ...
0
votes
0answers
29 views

Rails format date “%d / %m / %Y” not working

I've added a date_formatter.rb initializer with the following date_format = "%d / %m / %Y" Time::DATE_FORMATS[:default] = date_format Date::DATE_FORMATS[:default] = date_format When converting a ...
-1
votes
2answers
50 views

Can someone tell me the regex for a dateTimeString like: “YYYY/MM/DD HH:MM:SS” [closed]

Also, I'd really appreciate an explanation. Sorry, but I have never used regexes in my life and can barely read them.
8
votes
4answers
244 views

How can I write a “fluent” datetime value?

How do I Write C# code that will allow to compile the following code : var date = 8.September(2013); // Generates a DateTime for the 8th of September 2013
0
votes
1answer
20 views

SSRS Date Range Filter

I want to apply a Date Range filter on a report just like in SCSM Default report. In my report I used this query: IncidentDimvw.CreatedDate BETWEEN (@StartDate) AND (@ENDDATE) In the parameter ...

1 2 3 4 5 … 862
15 30 50 per page