Is there a way to use ‘the beginning of time’ in SQL

I’ve done a bit of research around this site and through Google and can’t seem to find what I’m looking for, I’m fairly new to SQL so there’s a chance I’ve missed or misunderstood something already but basically, I’m trying to do a report and usually I use

where (realdate = '2015-02-28')


datenow BETWEEN '2015-04-01' AND '2015-04-30'

Both of these usually serve me well but I’m trying to find out everything from ‘the beginning of time’ until the current date. I haven’t been able to find anything to do with this yet, besides a question someone else asked on another side that was sadly, unanswered.

Any help or just a point in the right direction will be appreciated.


Source: sql

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.