Skip to Content
avatar image
Former Member

Datetime to Date in BODS

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Dec 29, 2016 at 09:57 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 30, 2016 at 11:08 AM

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

    Add comment
    10|10000 characters needed characters exceeded