DSXchange

Hi,

i have an input seq file
i have input like this

column1
----------
2.49558695
6.766
9.18347580
3.495
2.494020

the column datatype is decimal

the out put like this
column1
--------
.495
.766
.183
.495
.494

Thanks for responding .can u give me a syntax of entire function i know convert function.but i am not getting in this scenario how to use conver().

i have a input
col
----
aa123
34bbb
567kk

i want two output like
output1
col
----
aa
bbb
kk

and second output like
col
----
123
34
567

anbu wrote:date1 and date2 are two parameters to the function

Code: Select all

DaysSinceFromDate(date2, date1)

Before answering question see once.dont give wrong answers.how to subtract dates using dayssincefromdate .once u go through the syntax