[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
[sqr-users] SQR Informix date format
- Subject: [sqr-users] SQR Informix date format
- From: Jeet <jitu_hansraj@yahoo.com>
- Date: Tue, 20 Sep 2005 15:33:07 -0700 (PDT)
- Delivery-date: Tue, 20 Sep 2005 17:34:12 -0500
- Domainkey-signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding;b=ceuiH8eFSrqEPF9PQorfoFjHgg3cZF2BqVVxO4K/KjS9IidL5SkOlvn+oes+938WqEvXlmKmhgOWJbg34UcLhEnRaMTdD9RdapjLFWsql7kLigH0j15PtVvLBBNTwUq/dxRUPEKM9Zh09MAVcQ47cWmZuGNtW3gbMs8Ov/xPsq0=;
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
Hi All,
I am writing a SQR report with Informix as database.
When I am inserting a row into the table thru the SQR,
the Informix is not accepting the date. For example,
let $insertDate = '09/20/2005'
Insert into ps_sample_table
(Setid,
Effdt,
Name,
Age)
Values
('Share',
$insertDate,
'John',
'25')
It always throws an error as follows
"(SQR 5528) INFORMIX SQL EXECUTE IMMEDIATE error ".
I tried changing the date variable in different
datatype as follows
let $convInsDate = datetostr($insertDate,'MM/DD/YYYY')
or
let $insertDate = '2005-MM-DD'
let $convInsDate = datetostr($insertDate,'YYYY-MM-DD')
and tried inserting using the $convInsDate variable.
But for some reason, it always errors out giving the
same reason.
Can anyone shed some light on this problem I am
facing. I will appreciate any suggestions you might
have.
Thanks a lot in advance.
- Jeet.
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users