Store datetime field as String

Article View: borland.public.interbase.sql

Article #794

Back to borland.public.interbase.sql Previous Next

#794

From: Craig Cookesley
Date: Tue, 08 May 2007 11:34

15 lines
1115 bytes

Hi

I need to update a field defined as varchar(8) with a datetime field in a 
trigger

The field is used extensive in code so to change the field type would be a 
big job

i was hoping to cast or convert the datatime field to string before update

Any ideas would be appreciated

Thanks in advance

Craig

Technical Details

Message-ID: <4640605c@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,d8456dd5bcafd5a4,start
X-Google-Attributes: gid114a0e,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Craig Cookesley" <ccc@planet.net.au>
Newsgroups: borland.public.interbase.sql
Subject: Store datetime field as String
Date: Tue, 8 May 2007 21:34:52 +1000
Lines: 17
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
NNTP-Posting-Host: 203.214.50.155
Message-ID: <4640605c@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1178624092 203.214.50.155 (8 May 2007 04:34:52 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail