× Data Warehousing and Data integration

Truncating Date to remove Time Part

  • Posts: 13
  • Thank you received: 0

Truncating Date to remove Time Part was created by Jim

Hi guys

I would like to truncate a date to just the MM/DD/YYYY format by removing the time part?
Is there a way to do it just by using inbuilt functions?

Ex: Incoming value 01/01/2012 10:10:10.777777

Output should be - 01/01/2012

Please advise.
Jim B
8 years 8 months ago #4583

Please Log in or Create an account to join the conversation.

  • Posts: 13
  • Thank you received: 0

Replied by Jim on topic Re: Truncating Date to remove Time Part

Anyone?
8 years 8 months ago #4584

Please Log in or Create an account to join the conversation.

  • Posts: 7946
  • Karma: 33
  • Thank you received: 495

Replied by admin on topic Re: Truncating Date to remove Time Part

Use splitter for that.
Set delimiter to SPACE

See attached files,

Peter
Mike
8 years 8 months ago #4585
Attachments:

Please Log in or Create an account to join the conversation.

This site uses cookies. By continuing to browse the site, you are agreeing to our use of cookies