Format yyyy-MM-dd'T'HH:mm:ss.SSS'Z'

Ash7
Ash7 Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Registered Posts: 2 ✭✭✭
in Using Dataiku

Hello,

I want to create a hive dataset to extract only the row with a "dat_trt" >= system date - 2 days.

cap_dataiku_1.PNG

cap_dataiku_0.PNG

Which sql function I should use please.

Thanks

Tagged:
· Share on Facebook

Best Answer

  • Liev
    Liev Dataiker Alumni Posts: 176 ✭✭✭✭✭✭✭✭
    Answer ✓

    Hi @Ash7

    While this is a Hive (and not DSS) question, you can refer to threads such as this one for some guidance and options. It seems it will depend on your Hive version of course.

    You can try these things out in a Hive notebook in DSS as well.

    Good luck!

    · Share on Facebook

Answers

  • Ash7
    Ash7 Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Registered Posts: 2 ✭✭✭

    thanks

    · Share on Facebook
Bookmark this topic

Categories

Setup Info
    Tags
      Help me…