HomeForum
Welcome, Guest
ETL-Forum
Forum
Data Warehousing and Data integration

Remove the time part
(1 viewing) (1) Guest
Data Warehousing and Data integration
Reply Topic
New Topic
  • Page:
  • 1

TOPIC: Remove the time part

Remove the time part 4 months, 2 weeks ago #4390

  • Jan
  • OFFLINE
  • Fresh Boarder
  • Posts: 2
  • Karma: 0
Dear support

I need to load only the date part to the target.
The target field data type is date.
How can I Remove the time part?

Thanks in advance for any reply.
Jan
Reply Quote

Re: Remove the time part 4 months, 2 weeks ago #4391

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2183
  • Karma: 12
If your target field is "date" type it should work straight away.

if it is "datetime" you can use splitter to extract separate date parts than combine it again using joiner
Your result string should look like this 2000-12-02 00:00:00

Mike
Reply Quote
Reply Topic
New Topic
  • Page:
  • 1
ETL-Forum
Forum
Data Warehousing and Data integration
Powered by Kunena
Time to create page: 0.15 seconds

Testimonials

"In my personal view, currently there are no other data transformation tools on the market that provide the same value for money as Advanced ETL Processor. The number of features is constantly increasing and If something is missing the will add it for you  ..."

Gabriell Mellotto, Senior ETL Consultant

User Login

You only need to log in or register to use our support forum



Our customers

BP

BBC

HSBC

Databases we work with

Submit to Delicious Submit to Digg Submit to Facebook Submit to Google Bookmarks Submit to Stumbleupon Submit to Technorati Submit to Twitter Submit to LinkedIn
Go to top