Top "Sql-date-functions" questions

The SQL-Date-Functions tag is for questions related to database SQL functions that handle date and time information.

Oracle date function for the previous month

I have the query below where the date is hard-coded. My objective is to remove the harcoded date; the query …

sql oracle sql-date-functions
Mysql DATE_SUB(NOW(), INTERVAL 1 DAY) 24 hours or weekday?

I am trying to get the total amount of registered users per day. At the moment I am using this: $…

mysql date sql-date-functions
Filter data based on date in sql

Im trying to execute the following SQL query and filter out the data based on the date. I need to …

sql sql-server sql-server-2008 sql-date-functions sqldatetime
First day of the next month

I'm trying get the results where it only displays OrderDates before the LAST day of the CURRENT month. I'm guessing …

sql sql-server tsql sql-date-functions
How can I use SQL's YEAR(), MONTH() and DAY() in Doctrine2?

I want to perform a query which would look like this in native SQL: SELECT AVG(t.column) AS average_…

mysql sql doctrine-orm sql-date-functions
SQL Select Records based on current date minus two days

I have an orders table which contains an order ID, order date and order description. I want to run a …

sql sql-server select getdate sql-date-functions
Converting java.sql.Date & java.util.Date to org.joda.time.LocalDate

I am trying to carefully and meticulously clean up some of my older (production) code. One thing I am trying …

java sql jodatime sql-date-functions
Is there a function that takes a year, month and day to create a date in PostgreSQL?

In the docs I could only find a way to create a date from a string, e.g. DATE '2000…

sql postgresql sql-date-functions
Oracle to_date function with quarter-format

I need to find some records created in a range of quarters. For example, I'm looking for all records created …

sql oracle oracle10g sql-date-functions
How to parse String to java.sql.date

I have a String String s = "01 NOVEMBER 2012"; Then I want parse it to sqlDate. And insert it into the database. …

java date sql-date-functions