Skip to main content
Question

Migration Job - VALID_FROM

  • December 1, 2021
  • 3 replies
  • 81 views

Forum|alt.badge.img+16

Community, 

i am doing supplier price list migration job, INSERT, one default filed i would like to have it defaulted to “03-31-2022”. but the issue is, whatever i changed the date format, system always prompted me error.

how to correct this?

 

Thank you.

This topic has been closed for replies.

3 replies

Forum|alt.badge.img+16
  • Author
  • Hero (Customer)
  • December 1, 2021

this is the screenshot.


dsj
Ultimate Hero (Partner)
Forum|alt.badge.img+22
  • Ultimate Hero (Partner)
  • December 2, 2021

Hi @ronhu 

use TO_DATE('3/31/2022', 'MM/DD/YYYY')

 

Cheers!

Damith


Forum|alt.badge.img+16
  • Author
  • Hero (Customer)
  • December 2, 2021

@dsj Thank you.