59
votes
10
answers
1.6K
views
What is the standard way to add N seconds to datetime.time in Python?
Given a datetime.time value in Python, is there a standard way to add an integer number of seconds to it, so t
56
votes
30
answers
439
views
Determine Whether Two Date Ranges Overlap
Given two date ranges, what is the simplest or most efficient way to determine whether the two date ranges ove
59
votes
15
answers
405
views
MySQL Query GROUP BY day / month / year
Is it possible to make a simple query to count how many records I have in a determined period of time like a y
58
votes
26
answers
1.9K
views
How do you set a default value for a MySQL Datetime column?
How do you set a default value for a MySQL Datetime column? In SQL Server it's getdate(). What is the eq
58
votes
20
answers
484
views
MySQL error code: 1175 during UPDATE in MySQL Workbench
I'm trying to update the column visited to give it the value 1. I use MySQL workbench, and I'm writi
52
votes
30
answers
926
views
Should I use the datetime or timestamp data type in MySQL?
Would you recommend using a datetime or a timestamp field, and why (using MySQL)? I'm working with PHP
62
votes
14
answers
1.7K
views
YYYY-MM-DD format date in shell script
I tried using $(date) in my bash shell script, however, I want the date in YYYY-MM-DD format. How do I get thi
61
votes
9
answers
2.5K
views
java.util.Date to XMLGregorianCalendar
Isn't there a convenient way of getting from a java.util.Date to a XMLGregorianCalendar?
53
votes
13
answers
2.3K
views
Converting between datetime, Timestamp and datetime64
How do I convert a numpy.datetime64 object to a datetime.datetime (or Timestamp)? In the following code, I cr
59
votes
4
answers
3.2K
views
How to format date and time in XAML in Xamarin application
I have a set up XAML code below. <Label Text="{Binding Date}"></Label> <Label Text="{Binding T
61
votes
1
answers
2.1K
views
Android app starts updating with cordova-webintent and force stops
Steps: I Opened the android application (built with cordova) Then I called cordova-webintent for installing u
50
votes
30
answers
2.1K
views
Not showing placeholder for input type="date" field
I am doing a phonegap app. When I am trying type="date" input field as shown below, it shows date picker in iP
66
votes
30
answers
523
views
Difference in months between two dates
How to calculate the difference in months between two dates in C#? Is there is equivalent of VB's DateDi
52
votes
30
answers
2.3K
views
How can I update NodeJS and NPM to the next versions?
I just installed Node.js and npm (for additional modules). How can I update Node.js and the modules which I&a
54
votes
24
answers
2.6K
views
Converting string into datetime
I've got a huge list of date-times like this as strings: Jun 1 2005 1:33PM Aug 28 1999 12:00AM I&apos
66
votes
30
answers
965
views
53
votes
15
answers
1.6K
views
Find objects between two dates MongoDB
I've been playing around storing tweets inside mongodb, each object looks like this: { "_id" : ObjectId(
61
votes
16
answers
2.1K
views
DateTime2 vs DateTime in SQL Server
Which one: datetime datetime2 is the recommended way to store date and time in SQL Server 2008+? I'm a
54
votes
11
answers
1.1K
views
Insert into a MySQL table or update if exists
I want to add a row to a database table, but if a row exists with the same unique key I want to update the row
61
votes
25
answers
3K
views
SQL update from one Table to another based on a ID match
I have a database with account numbers and card numbers. I match these to a file to update any card numbers to
