Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have two dates in two table in two different formants
Table 1 date1 31-Jan-2016
Table Date1 two different fields YEAR=2016 MONTH=1
I want make tem into uniform format to connect them to master cladender. plsd help me do so in data load script
for table 1, if you have
SET MonthNames='jan;feb;mar;apr;..........';
date( date# (date1, 'DD-MMM-YYYY'))
for table 2
makedate(YEAR, MONTH)
for table 1, if you have
SET MonthNames='jan;feb;mar;apr;..........';
date( date# (date1, 'DD-MMM-YYYY'))
for table 2
makedate(YEAR, MONTH)