Page 1 of 1

Posted: Tue Jun 24, 2003 1:39 am
by nelc
Two possible ways:

1)Use Field(input.InputDate, " ", 1,1) to extract based on space delimiter.
2)Left(InLink.TheTimeStamp, 10) to extract the first 10 chars. This was posted in another thread previously.

Hope it helps!
Good Luck!

Posted: Tue Jun 24, 2003 3:39 am
by roy
Hi,
Another idea is, in case you are using native DB stages:
you can define the datetime column as a date type in the source table's scheme.
this will result in getting the internal date representation of DS, which is an integer value, thus truncating the time part from the result set.
if you use the same DS's internal value to load to a target table, again in native stages, using a date data type, it should automatically translate it to the date value for you and there u have it [8D]


Roy R.

Posted: Tue Jun 24, 2003 3:44 am
by roy
p.s. (on my post)

u can use any Oconv() manipulation on the internal date number to format the date in your flavour in case you don't need to load it back to a db table.

( in case you are not familiour with Oconv search it in the DS help )

Roy R.