IQ Server - Converting a date field to Julian date

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Converting a date field to Julian date

mevasquez

2005-09-27, 8:25 pm

Is there a way to convert a datetime field in sybase to a
julian date? I have search and search and have not come up
with any answer.

TIA
Mike

Luis Porras

2005-10-27, 8:23 am

I don't know how IQ works... I use this "formula" to convert the current
date to julian format:

select
substring(convert(va
rchar(20),getdate(),
112),1,4)+'/ '+convert(varchar(20
),da
tediff(dd,convert(da
tetime,substring(con
vert(varchar(20),get
date(),112),1,4)
),convert(varchar(20
),getdate(),112)))

~Luis

<mevasquez> wrote in message news:4339c288.529b.1681692777@sybase.com...
> Is there a way to convert a datetime field in sybase to a
> julian date? I have search and search and have not come up
> with any answer.
>
> TIA
> Mike

Sponsored Links