Change Date Type Coming Out of Date Interface Tool to Match In-DB Field Date

estherb47

Hi,

I'm connecting to an Oracle DB, and I want to create a field that pulls just the year out of a datetime field.

So, I'd want 2017-01-02 to result in a value of 2017, which needs to be in integer format.

Thanks for your help!

Date Time

In Database

In-Database

Accepted answers

MarqueeCrew

@estherb47,

ok... how about:

EXTRACT(year FROM order_date)

i can webex with you now....

https://meetings.webex.com/collabs/meetings/join?uuid=M37I5AUGTGAAM8FCLXJK1FFVRX-UCSL&epwd=7e667c8e0a5a18004a555b

Cheers,

Mark

All comments

MarqueeCrew

hi @estherb47,

Have you tried:

ToNumber(DateTimeFormat([DateTime_Field],"%Y"))

That just might work.

Cheers,

Mark

estherb47

That looks like what I'd use in the regular formula tool. This is the In-DB
formula tool. Is it the same expression syntax?

--
Esther Bezborodko
*Manager*
201.650.7314 | estherbezborodko@gmail.com
beautycounter.com/estherbezborodko

*Our mission is to get safe products in the hands of everyone.*
[image: Facebook]

MarqueeCrew

@estherb47,

ok... how about:

EXTRACT(year FROM order_date)

i can webex with you now....

https://meetings.webex.com/collabs/meetings/join?uuid=M37I5AUGTGAAM8FCLXJK1FFVRX-UCSL&epwd=7e667c8e0a5a18004a555b

Cheers,

Mark

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15875

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703