Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Date exp. Year Format within Trigger on WIN NT

2 posts in Trigger Last posting was on 2005-01-07 15:04:19.0Z
Stefan Overath Posted on 2004-12-30 10:33:54.0Z
Reply-To: "Stefan Overath" <stefan.overath@team-wof.de>
From: "Stefan Overath" <stefan.overath@team-wof.de>
Newsgroups: Advantage.Trigger
Subject: Date exp. Year Format within Trigger on WIN NT
Date: Thu, 30 Dec 2004 11:33:54 +0100
Lines: 14
Organization: disdatas GmbH
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
NNTP-Posting-Host: 80.133.148.233
Message-ID: <41d3da71@solutions.advantagedatabase.com>
X-Trace: 30 Dec 2004 03:37:37 -0700, 80.133.148.233
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!80.133.148.233
Xref: solutions.advantagedatabase.com Advantage.Trigger:141
Article PK: 1136208

Hello!

I'va a problem with an trigger on WinNT
When I copy the triggered information with SQL to an trigger database all
dates are written with 2 chars in the year.
The International Setting on the server describes 4 chars for year.
Have anybody an idea how to resolve this?

Thanks!

Stefan Overath
disdatas GmbH & Co. KG


J.D. Mullin Posted on 2005-01-07 15:04:19.0Z
Message-ID: <20143632406816195099729@devzone.advantagedatabase.com>
From: J.D. Mullin <no@email.com>
Subject: Re: Date exp. Year Format within Trigger on WIN NT
Newsgroups: Advantage.Trigger
References: <41d3da71@solutions.advantagedatabase.com>
Content-Type: text/plain; charset=iso-8859-1; format=flowed
X-Newsreader: JetBrains Omea Reader 381.17
NNTP-Posting-Host: 198.102.102.75
Date: 7 Jan 2005 08:04:19 -0700
X-Trace: 7 Jan 2005 08:04:19 -0700, 198.102.102.75
Lines: 21
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!198.102.102.75
Xref: solutions.advantagedatabase.com Advantage.Trigger:142
Article PK: 1136211

Hi Stefan,

Can you post your trigger code and the table it runs on?

J.D. Mullin
Advantage R&D

> Hello!
>
> I'va a problem with an trigger on WinNT
> When I copy the triggered information with SQL to an trigger database
> all
> dates are written with 2 chars in the year.
> The International Setting on the server describes 4 chars for year.
> Have anybody an idea how to resolve this?
> Thanks!
>
> Stefan Overath
> disdatas GmbH & Co. KG