See DATE.UTILITIES :: http://www.pickwiki.com/cgi-bin/wiki.pl?DateUtility
This has functions to generate and parse ISO8601 dates with time zone
smarts.
deffun DATE.UTILITIES(Method,Arguments)isoDate =
DATE.UTILITIES('getISODateTime',LOCAL.DATE.FIELD:@AM:LOCAL.TIME.FIELD[:@AM:LOCAL.TZ.OFFSET])
crt isoDate ;* >> 1997-07-16T19:20+10:00
...
0001 I Current ISO8601 time0002
SUBR('DATE.UTILITIES','getISODateTime','')...
-----Original Message-----
From: gerry-u2ug
pulling data from universe 10 into sql server 2000 using uniOleDb and DTS ,
does anyone know of some way to take seperate DATE and TIME fields in
universe
and have SQL Server see them a single DATETIME field ?
...
that's half of the solution.
this solved the problem for DTS bulk copies which are smart to handle
string to datetime promotions
we also needed this to work via an intermediary process that used
DataAdapters which aren't smart enough to do the string to datetime
conversion - so I ended up doing the conversion myself in the source data
set using a couple of dummy columns.
it actually would be really nice if uv supported datetime field types too.
**********************************************************************
This email message and any files transmitted with it are confidential
and intended solely for the use of addressed recipient(s). If you have
received this email in error please notify the Spotless IS Support Centre (61 3
9269 7555) immediately who will advise further action.
This footnote also confirms that this email message has been scanned
for the presence of computer viruses.
**********************************************************************
-------
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
