Skip to Content
0

Datetime to Date in BODS

Dec 29, 2016 at 03:15 AM

121

avatar image

Hi All,

i need to populate sysdate in START_DATE and 12.31.9999 for my END_DATE in target columns, Both my these columns datatype are datetime.

I tried in many ways using functions but unable to achieve desired out put.

my desired output is

START_DATE( datetime)= Today date

END_DATE(datetime)=12.31.9999

Can anyone help me on this...

Regards

Vinay

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Arindam Ghosh Dec 29, 2016 at 09:57 AM
1

I don't think it is possible to see the value in Date format when the field is DATETIME type.You can CAST the sysdate to get the date but other values(sec, hrs etc.) will show as 00.

Share
10 |10000 characters needed characters left characters exceeded
Ravi kiran Pagidi Dec 30, 2016 at 11:08 AM
0

The columns START_DATE and END_DATE should be changed to date datatype.

Share
10 |10000 characters needed characters left characters exceeded