Re: can anyone tell me how to use DTS to convert a ISO date time to JAVA long type?
From: Darren Green (darren.green_at_reply-to-newsgroup-sqldts.com)
Date: 03/09/04
- Next message: Darren Green: "Re: Global variable retains its value in a scheduled package."
- Previous message: Mark: "Re: Where'd My FileObject Reference go in my VB Transformation Script?"
- In reply to: Victor.Liang: "can anyone tell me how to use DTS to convert a ISO date time to JAVA long type?"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 9 Mar 2004 18:03:25 +0000
In message <upO0tKaBEHA.2404@TK2MSFTNGP11.phx.gbl>, Victor.Liang
<victor.liang@timogen.com> writes
>Hi, guy
> There is a column which type is ISO DATE type in my source DB,
>And I want to convert this ISO date time to JAVA long time in my
>destination DB.
>
>can anyone tell me how to do this?
>
>
I thought most DBs, SQL Server included never stored a date in a
"format", but take the input and store it in an internal format, such as
number of time periods offset from a known date. This way the format is
not a DB issue at all, but a presentation issue.
If you are working with dates as strings, or date to string then you can
do this inside an ActiveX Script Transform. You can use date functions
such as Year, Month, DatePart and the Mid, Left string functions to
build a formatted date string.
If none of the above helps can you clarify the DB types involved, and
also gives an example of the formats you want.
-- Darren Green (SQL Server MVP) DTS - http://www.sqldts.com PASS - the definitive, global community for SQL Server professionals http://www.sqlpass.org
- Next message: Darren Green: "Re: Global variable retains its value in a scheduled package."
- Previous message: Mark: "Re: Where'd My FileObject Reference go in my VB Transformation Script?"
- In reply to: Victor.Liang: "can anyone tell me how to use DTS to convert a ISO date time to JAVA long type?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
