Tag: datetime

59 votes
10 answers
1.5K 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

avatar
Janella
0 1 0 9
asked 07 September, 2021
56 votes
30 answers
377 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

avatar
Juliane
0 1 0 9
asked 07 September, 2021
59 votes
15 answers
346 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

avatar
Lashawna
0 1 0 9
asked 07 September, 2021
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

avatar
Jesenia
0 1 0 9
asked 07 September, 2021
52 votes
30 answers
849 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

avatar
Trudy
0 1 0 9
asked 07 September, 2021
53 votes
13 answers
2.2K 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

avatar
Adolfo
0 1 0 9
asked 07 September, 2021
59 votes
4 answers
3.1K 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

avatar
Renaldo
0 1 0 9
asked 07 September, 2021
54 votes
24 answers
2.5K 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

avatar
Fabian
0 1 0 9
asked 07 September, 2021
66 votes
30 answers
913 views
How to get the current time in Python

What is the module/method used to get the current time?

avatar
Dario
0 1 0 9
asked 07 September, 2021
53 votes
15 answers
1.5K views
Find objects between two dates MongoDB

I've been playing around storing tweets inside mongodb, each object looks like this: { "_id" : ObjectId(

avatar
Kristopher
0 1 0 9
asked 07 September, 2021
61 votes
16 answers
2K 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

avatar
Hallie
0 1 0 9
asked 07 September, 2021
60 votes
30 answers
2.9K views
How to return only the Date from a SQL Server DateTime datatype

SELECT GETDATE() Returns: 2008-09-22 15:24:13.790 I want that date part without the time part: 2008-09-22 0

avatar
Corrin
0 1 0 9
asked 07 September, 2021
58 votes
30 answers
1.2K views
How do I get the current date and time in PHP?

Which PHP function can return the current date/time?

avatar
Lynette
0 1 0 9
asked 07 September, 2021