SEO

#1 (**permalink**) 02-28-2008, 05:56 PM

In our database is a decimal field with format YYMMDDhhmmss.9999999999
where the 9s are random digits. I'm trying to strip off just the
YYMMDD and put it in date form.

So far I came up with:
SUBSTR(TO_CHAR(rec_num,99999999999),1,6) AS Date which returns YMMDD.

For example where the rec_num is 30608124143.47069519725 the above
functions return 30608.

I tried wrapping another TO_CHAR around it to try to format it to a
date but this seems like it's a bit much for this purpose.

Any suggestions would be appreciated.

-David

#2 (**permalink**) 02-28-2008, 05:56 PM

"wireless" <wireless200@yahoo.com> wrote in message
news:90446ee7.0309161123.ae79c7e@posting.google.co m...
> In our database is a decimal field with format YYMMDDhhmmss.9999999999
> where the 9s are random digits. I'm trying to strip off just the
> YYMMDD and put it in date form.
>
> So far I came up with:
> SUBSTR(TO_CHAR(rec_num,99999999999),1,6) AS Date which returns YMMDD.
>
> For example where the rec_num is 30608124143.47069519725 the above
> functions return 30608.
>
> I tried wrapping another TO_CHAR around it to try to format it to a
> date but this seems like it's a bit much for this purpose.
>
> Any suggestions would be appreciated.
>
> -David

I think you may have posted this to the wrong group - SUBSTR() and TO_CHAR()
are not MS SQL Server functions.

Simon

#3 (**permalink**) 02-28-2008, 05:57 PM

"Simon Hayes" <sql@hayes.ch> wrote:

> I think you may have posted this to the wrong group - SUBSTR() and TO_CHAR()
> are not MS SQL Server functions.

Yes, right. We've got three different database types here (MS,
Oracle,and Postgre) and sometimes the tsql runs together with the
psql.

?

-David (I wish they were all sql servers)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

how to get decimal to date form