Top "Date" questions

Check if current date is between two dates Oracle SQL

I would like to select 1 if current date falls between 2 dates through Oracle SQL. I wrote an SQL after reading …

sql oracle date between sysdate

Difference between two dates in Python

I have two different dates and I want to know the difference in days between them. The format of the …

python date

Difference between two dates in MySQL

How to calculate the difference between two dates, in the format YYYY-MM-DD hh: mm: ss and to get the result …

mysql sql date datetime

MySQL date formats - difficulty Inserting a date

I am trying to further a question I asked yesterday where I wanted to know how to query a date …

mysql date insert format

Get the date (a day before current time) in Bash

How can I print the date which is a day before current time in Bash?

bash unix date solaris

How can I compare two dates in PHP?

How can I compare two dates in PHP? The date is stored in the database in the following format 2011-10…

php date compare

In Python, how do you convert seconds since epoch to a `datetime` object?

The time module can be initialized using seconds since epoch: >>> import time >>> t1=time.…

python datetime date time epoch

Difference between datetime and timestamp in sqlserver?

What is the difference between Timestamp and Datetime SQL Server? I thought Both formats are capable of storing date + time. …

sql sql-server date time

Oracle SQL - DATE greater than statement

As the title says, I want to find a way to check which of my data sets are past 6 months …

sql oracle date format

Date Difference in php on days?

Is there a quick way to calculate date difference in php? For example: $date1 = '2009-11-12 12:09:08'; $date2 = '2009…

php date datediff