How to enable Javascript

0

Date between

HK
Wipro
Harikrishna_Kammam
2 wk ago
2 replies
14
KHK2 wk ago
Questions & Answers

Hi,

Can you please let me know how to write below condition in materialized view in where condition?

To_date(WSH.WSH_NEW_DELIVERIES.ATTRIBUTE1, 'DD-MON-YYYY') BETWEEN TRUNC(sysdate -2) AND trunc(sysdate +2) )

Regards,

KHK.

Like Follow

- Amit KothariEmployee
- Incorta
- Amit_Kothari
- 2 wk ago
- 1
- Questions & Answers
- Reported - view
To_date(WSH.WSH_NEW_DELIVERIES.ATTRIBUTE1, 'dd-MMM-yyyy') BETWEEN date_sub(current_date,2) and date_add(current_date,2)

Refer -

https://jaceklaskowski.gitbooks.io/mastering-spark-sql/content/spark-sql-functions-datetime.html

Like 1
- KHK
  
  Wipro
  
  Hari_K
  
  2 wk ago
  
  Reported - view
  Amit Kothari Thank you. Condition Working fine.
  
  Like

Login to reply

Like Follow

2 wk agoLast active
2Replies
14Views
3 Following

Login to reply

cancel

Mention someone by typing their name

No matching users