date-manipulation Questions
29
I'd like to get a Date object which is 30 minutes later than another Date object. How do I do it with JavaScript?
Zooplankton asked 29/7, 2009 at 3:34
5
Solved
I need to calculate the weeks out from a date in my MySQL select statement. There is a date column in one of the tables, and I need to calculate how many weeks away the date is.
SELECT EventDate, ...
Iraq asked 18/10, 2010 at 14:58
4
Solved
I can't seem to find an answer to this anywhere --- I want to convert a datetime in SQL to the excel serial number.
I'm essentially looking for the DATEVALUE function from excel but for use in SQL...
Loewe asked 9/11, 2016 at 20:55
4
I've successfully converted something of 26 Sep 2012 format to 26-09-2012 using:
datetime.strptime(request.POST['sample_date'],'%d %b %Y')
However, I don't know how to set the hour and minute of s...
Glassblowing asked 18/9, 2012 at 0:22
14
Solved
I need the start date and the end date of the current month in Java. When the JSP page is loaded with the current month it should automatically calculate the start and end date of that month. It sh...
Ammeter asked 21/6, 2010 at 10:17
9
Solved
Say I have a string coming in, "2007-02-28", what's the simplest code I could write to turn that into "2007-03-01"? Right now I'm just using strtotime(), then adding 24*60*60, then using date(), bu...
English asked 18/3, 2009 at 23:34
8
Solved
I'm trying to convert a MM/DD/YYYY date to a long date. So for example, 02/12/2013 would convert to something like Tuesday February 12 2013.
I've looked at MomentJS and other JS methods, but noth...
Bedplate asked 14/9, 2016 at 16:3
5
Solved
I have a date time of my django object but it can be any time of the day. It can be at any time through the day, but I need to set my time to 00:00:00 (and another date to 23:59:59 but the principl...
Evaevacuant asked 2/12, 2011 at 18:47
4
Solved
I want to update a DateTime column where it will change the hours only without modifying anything else. I can't use to add an interval as the values all are different. There is many different dates...
Megalopolis asked 4/7, 2017 at 6:32
6
What would be the best way to compare two dates?
var int = e.parameter.intlistbox;
var startDate = rSheet.getRange(parseInt(int) + 1 ,1).getValues();
// returns Sat Jun 30 2012 00:00:00 GMT-0300 ...
Beacham asked 24/6, 2012 at 1:39
5
Solved
Over the years I have come across different interpretations of the end of a day.
But what is the correct way of representing it when comparing dates and intervals?
I have found that some people se...
Yorker asked 7/10, 2014 at 23:1
2
Solved
I need two or one (out) C# method that will take any datetime and return the start date of year and end date of year for that year.
Gibun asked 23/5, 2010 at 10:4
9
Solved
I have a table that containts a set of columns one of it is a Date column.
I need to count how many occurrences of the values of that column refer to the same month. And return if for one month, t...
Crocodile asked 3/3, 2010 at 23:18
1
© 2022 - 2024 — McMap. All rights reserved.