Convert to date question

Article View: borland.public.interbase.sql

Article #787

Back to borland.public.interbase.sql Previous Next

#787

From: zeke
Date: Mon, 16 Jul 2007 16:07

18 lines
1748 bytes

I need to convert a numeric field to a date in a view.  I tried using
cast but receive a conversion error.  I'm not familiar with interbase,
but the same process in sql server returns the following
information...

example data:
38991 = 10/1/2006

All of the data is stored in a numeric format similar to the above,
but I need to convert it to a readable time format in the view.

This is the code that returns the error:
select cast(numericdatefield as date) from table1

The same sql works perfectly in sql server, but I am not familiar with
interbase syntax.

Any help is appreciated.

Technical Details

Message-ID: <1184602057.554493.197770@o61g2000hsh.googlegroups.com>

Path: arc1-ca.pugleaf.net!g2news1.google.com!postnews.google.com!o61g2000hsh.googlegroups.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,f43f57f339ab6cb4,start
X-Google-Attributes: gid114a0e,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
Path: arc1-ca.pugleaf.net!g2news1.google.com!postnews.google.com!o61g2000hsh.googlegroups.com!not-for-mail
From:  zeke <turf04@hotmail.com>
Newsgroups: borland.public.interbase.sql
Subject: Convert to date question
Date: Mon, 16 Jul 2007 09:07:37 -0700
Organization: http://groups.google.com
Lines: 19
Message-ID: <1184602057.554493.197770@o61g2000hsh.googlegroups.com>
NNTP-Posting-Host: 64.118.141.226
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1184602057 11444 127.0.0.1 (16 Jul 2007 16:07:37 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Mon, 16 Jul 2007 16:07:37 +0000 (UTC)
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 2.0.50727; .NET CLR 1.1.4322; .NET CLR 3.0.04506.30),gzip(gfe),gzip(gfe)
X-HTTP-Via: 1.1 NTISA
Complaints-To: groups-abuse@google.com
Injection-Info: o61g2000hsh.googlegroups.com; posting-host=64.118.141.226;
   posting-account=ps2QrAMAAAA6_jCuRt2JEIpn5Otqf_w0