Newest 'sql-date-functions+sql+select' Questions

1 vote

2 answers

69 views

SQL Conditional Return HAVING

I have been unable to find the WHERE or HAVING condition that helps me return the following: If a user has activity logged within the past month, I want to return records for the past six (6) months ...

paaskanama

asked Sep 2, 2018 at 17:25

8 votes

4 answers

64k views

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 select query which captures all orders that have been created in the last two days. so the current ...

Emma

asked Dec 14, 2017 at 16:41

1 vote

0 answers

2k views

Oracle database Date to Timezone format yyyy-MM-dd'T'HH:mm:ss.SSSXXX

I'm trying to retrieve a timestamp date field from database using a Select query such that the timestamp date should be returned as yyyy-MM-ddTHH:mm:ss.SSSXXX format. I'm able to process it using ...

enigma

asked Mar 17, 2016 at 21:48

Collectives™ on Stack Overflow

All Questions