Oracle Adapter and Date/Time Format

BizTalk Utilities

Xselerator XSLT IDE

Forum main page

Most active member

Search page

View our event calendar
Add general event such as an upcoming software release or conference
View all birthdays

Public image gallery
Upload your images in your profile

Profile editing page
Subscription list page
Address book page

Member list page
View the most active member
User groups listing
Private message page

TopXML Discussion Forum

Forums Register Login My Profile Inbox Address Book My Subscription My Forums

Photo Gallery Member List Search Calendars FAQ Ticket List Log Out

Oracle Adapter and Date/Time Format

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> [BizTalk Utilities] >> BizTalk 2004/2006 Utilities and Adapters >> Oracle Adapter and Date/Time Format

Page: [1]

Message

<< Older Topic Newer Topic >>

Oracle Adapter and Date/Time Format - 8 January 2007

shamir.ali

Posts: 17
Score: 0
Joined: 28 December 2006
Status: offline

Hello,

Could any one please tell me that how can i change an incoming date/time format from the oracle database, before the mapping. Is there any functoid. Source schema is an auto generated service's request schema and destination is my own schema that i fianlly write into a text file. At the moment the date coming from oracle looks like this when it transforms it and makes an txt file:

2004-12-03T12:45:00.0000000+05:00
Is there a way to change the format of the date/time to a customize format like "dd/mm/yyyyhh:mm"

Thanks

Post #: 1

RE: Oracle Adapter and Date/Time Format - 8 January 2007

shamir.ali

Posts: 17
Score: 0
Joined: 28 December 2006
Status: offline

got the solution by using a scripting functoid.

Thanx

(in reply to shamir.ali)

Post #: 2

RE: Oracle Adapter and Date/Time Format - 8 January 2007

Pieter

Posts: 615
Score: 2
Joined: 8 March 2004
Status: offline

The format you are seeing here is the standard Xml Format for DateTime values.

The simples way to change this is to use a scripting functoid or assembly inside your map.

All it needs to do is to convert the value to a DateTime and then use the overloaded ToString() method on DateTime to format the DateTime time to your requirements.

Antoher approach would be to use an Oracle Function to convert this to the correct format and pass it back as a string value to BTS.

_____________________________

Need a BizTalk Adapter? Visit http://www.topxml.com/biztalkutilities and check out the latest BizTalk Adapters.

(in reply to shamir.ali)

Post #: 3