Forum: >>> Magnum BBS <<<

[Info-ingres] The 'is ingresdate' predicate and II_DATE_FORMAT

From Martin Bowes@21:1/5 to All on Tue Apr 6 07:23:33 2021

Hi All,

In my innocence I assumed that the 'is ingresdate' predicate would work using the current session setting of II_DATE_FORMAT. That variable can after all be set locally to override the global setting used in the installation. Given that many input date
formats are valid in some settings but not in others, using the session setting makes sense to me.

So for example my installation has II_DATE_FORMAT=multinational4. So todays date would be generated as '06/04/2021'

But...
EXPORT II_DATE_FORMAT=SWEDEN
sql iidbdb <<SQL_END
select dbmsinfo('date_format'); ��
�col1 � ��
�finland � ��
select date('today')\g
��
�col1 �
��
�2021-04-06 �
��
(1 row)
select case when '2021-04-06' is ingresdate then 'valid' else 'invalid' end\g ��
�col1 �
��
�invalid� <-- Well that's a bit of a shock.
��
(1 row)
select case when '06/04/2021' is ingresdate then 'valid' else 'invalid' end ��
�col1 �
��
�valid �<-- This is correct, as that date string is valid date input in Sweden ��
(1 row)

So is the 'is ingresdate' predicate only respecting the installation wide setting of II_DATE_FORMAT or is this a bug in the processing?

Note I've tried the above using the set date_format 'sweden' command with the same result.

Martin Bowes

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=koi8-r">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)"> <style><!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:"Lucida Console";
panose-1:2 11 6 9 4 5 4 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}

</style><!--[if gte mso 9]><xml>

<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]-->
</head>
<body lang="EN-GB" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
Hi All,<o:p></o:p>
<o:p> </o:p>
In my innocence I assumed that the ‘is ingresdate’ predicate would work
using the current session setting of II_DATE_FORMAT. That variable can after all be set locally to override the global setting used in the installation. Given that many input date formats are valid in some settings but not in others, using the
session
setting makes sense to me.<o:p></o:p>
<o:p> </o:p>
So for example my installation has II_DATE_FORMAT=multinational4. So todays date would be generated as ‘06/04/2021’<o:p></o:p>
<o:p> </o:p>
But…<o:p></o:p>
EXPORT II_DATE_FORMAT=SWEDEN<o:p></o:p>
sql iidbdb <<SQL_END<o:p></o:p>
select dbmsinfo(‘date_format’);<o:p></o:p> ��<o:p></o:p>
�col1                     &
nbsp;                                      �<o:p></o:p>
��<o:p></o:p>
�finland                     &
nbsp;                                   �<o:p></o:p>
��<o:p></o:p>
select date('today')\g<o:p></o:p>
��<o:p></o:p>
�col1                     �<o:p></o:

��<o:p></o:p>
�2021-04-06               �<o:p></o:p>
��<o:p></o:p>
(1 row)<o:p></o:p>
select case when '2021-04-06' is ingresdate then 'valid' else 'invalid' end\g<o:p></o:p>
��<o:p></o:p>
�col1   �<o:p></o:p>
��<o:p></o:p>
�invalid�
ß Well that’s a bit of a shock.<o:p></o:p>
��<o:p></o:p>
(1 row)<o:p></o:p>
select case when '06/04/2021' is ingresdate then 'valid' else 'invalid' end<o:p></o:p>
��<o:p></o:p>
�col1   �<o:p></o:p>
��<o:p></o:p>
�valid  �ß This is correct,
as that date string is valid date input in Sweden<o:p></o:p>
��<o:p></o:p>
(1 row)<o:p></o:p>
<o:p> </o:p>
So is the ‘is ingresdate’ predicate only respecting the installation wide setting of II_DATE_FORMAT or is this a bug in the processing?<o:p></o:p>
<o:p> </o:p>
Note I’ve tried the above using the set date_format ‘sweden’ command with the same result.
<o:p></o:p>
<o:p> </o:p>
Martin Bowes<o:p></o:p>
</div>
</body>
</html>

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

From Martin Bowes@21:1/5 to All on Tue Apr 6 09:52:11 2021

SGkgS2FybCwNCg0KSWYgdGhleSBoYXZlIGZpbnMsIGRvIHRoZXkgZXZlbiBoYXZlIHRvZXM/DQoN ClRoaXMgaXMgc291bmRpbmcgbW9yZSBsaWtlIGFuIGlzc3VlIEknbGwgcmFpc2UgdG8gc2VlayBj bGFyaWZpY2F0aW9uLg0KDQpNYXJ0eQ0KDQotLS0tLU9yaWdpbmFsIE1lc3NhZ2UtLS0tLQ0KRnJv bTogS2FybCBTY2hlbmRlbCA8c2NoZW5kZWxAa2Jjb21wdXRlci5jb20+DQpTZW50OiAwNiBBcHJp bCAyMDIxIDEwOjM3DQpUbzogTWFydGluIEJvd2VzIDxtYXJ0aW4uYm93ZXNAbmRwaC5veC5hYy51 az4NClN1YmplY3Q6IFJlOiBbSW5mby1pbmdyZXNdIFRoZSAnaXMgaW5ncmVzZGF0ZScgcHJlZGlj YXRlIGFuZCBJSV9EQVRFX0ZPUk1BVA0KDQpNYXJ0eSwgeW91J3JlIGxvb2tpbmcgZm9yIGNvbnNp c3RlbmN5LiBPaywNCg0KQnV0IHdhaXQuICBZb3UgYXNrZWQgZm9yIFN3ZWRlbiBkYXRlIGZvcm1h dCBhbmQgaXQgdG9sZCB5b3UgRmlubGFuZC4NClRoYXQgc2hvdWxkIGhhdmUgYmVlbiB5b3VyIGZp cnN0IGhpbnQuLi50aG9zZSBGaW5ucyBjYW4ndCBiZSB0cnVzdGVkIHRvIGNvdW50IHRoZWlyIHRv ZXMuLi4NCg0KKGFuZCBpZiB5b3UgcHJldGVuZCB0aGF0IGFueW9uZSBmcm9tIEFjdGlhbiBhbnN3 ZXJlZCB5b3UsIHNlZSB0cnVtcCwgbWF0dCBnYWV0eiwgZXRjIGV0YyEpDQoNCkthcmwNCg0KDQo+ IE9uIEFwciA2LCAyMDIxLCBhdCAzOjIzIEFNLCBNYXJ0aW4gQm93ZXMgPG1hcnRpbi5ib3dlc0Bu ZHBoLm94LmFjLnVrPiB3cm90ZToNCj4gDQo+IEhpIEFsbCwNCj4gIA0KPiBJbiBteSBpbm5vY2Vu Y2UgSSBhc3N1bWVkIHRoYXQgdGhlIOKAmGlzIGluZ3Jlc2RhdGXigJkgcHJlZGljYXRlIHdvdWxk IHdvcmsgdXNpbmcgdGhlIGN1cnJlbnQgc2Vzc2lvbiBzZXR0aW5nIG9mIElJX0RBVEVfRk9STUFU LiBUaGF0IHZhcmlhYmxlIGNhbiBhZnRlciBhbGwgYmUgc2V0IGxvY2FsbHkgdG8gb3ZlcnJpZGUg dGhlIGdsb2JhbCBzZXR0aW5nIHVzZWQgaW4gdGhlIGluc3RhbGxhdGlvbi4gR2l2ZW4gdGhhdCBt YW55IGlucHV0IGRhdGUgZm9ybWF0cyBhcmUgdmFsaWQgaW4gc29tZSBzZXR0aW5ncyBidXQgbm90 IGluIG90aGVycywgdXNpbmcgdGhlIHNlc3Npb24gc2V0dGluZyBtYWtlcyBzZW5zZSB0byBtZS4N Cj4gIA0KPiBTbyBmb3IgZXhhbXBsZSBteSBpbnN0YWxsYXRpb24gaGFzIElJX0RBVEVfRk9STUFU PW11bHRpbmF0aW9uYWw0LiBTbyB0b2RheXMgZGF0ZSB3b3VsZCBiZSBnZW5lcmF0ZWQgYXMg4oCY MDYvMDQvMjAyMeKAmQ0KPiAgDQo+IEJ1dOKApg0KPiBFWFBPUlQgSUlfREFURV9GT1JNQVQ9U1dF REVODQo+IHNxbCBpaWRiZGIgPDxTUUxfRU5EDQo+IHNlbGVjdCBkYm1zaW5mbyjigJhkYXRlX2Zv cm1hdOKAmSk7DQo+IOKUjOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKU gOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKU gOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKU gOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUkA0KPiDilIJjb2wxICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg4pSC DQo+IOKUnOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKU gOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKU gOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKU gOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUpA0KPiDilIJmaW5sYW5kICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg4pSCDQo+IOKUlOKU gOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKU gOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKU gOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKU gOKUgOKUgOKUgOKUgOKUgOKUgOKUmA0KPiBzZWxlY3QgZGF0ZSgndG9kYXknKVxnDQo+IOKUjOKU gOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKU gOKUgOKUgOKUgOKUgOKUgOKUkA0KPiDilIJjb2wxICAgICAgICAgICAgICAgICAgICAg4pSCDQo+ IOKUnOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKU gOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUpA0KPiDilIIyMDIxLTA0LTA2ICAgICAgICAgICAgICAg 4pSCDQo+IOKUlOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKU gOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUmA0KPiAoMSByb3cpDQo+IHNlbGVjdCBjYXNl IHdoZW4gJzIwMjEtMDQtMDYnIGlzIGluZ3Jlc2RhdGUgdGhlbiAndmFsaWQnIGVsc2UgDQo+ICdp bnZhbGlkJyBlbmRcZyDilIzilIDilIDilIDilIDilIDilIDilIDilJANCj4g4pSCY29sMSAgIOKU gg0KPiDilJzilIDilIDilIDilIDilIDilIDilIDilKQNCj4g4pSCaW52YWxpZOKUgiDDnyBXZWxs IHRoYXTigJlzIGEgYml0IG9mIGEgc2hvY2suDQo+IOKUlOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKU mA0KPiAoMSByb3cpDQo+IHNlbGVjdCBjYXNlIHdoZW4gJzA2LzA0LzIwMjEnIGlzIGluZ3Jlc2Rh dGUgdGhlbiAndmFsaWQnIGVsc2UgDQo+ICdpbnZhbGlkJyBlbmQg4pSM4pSA4pSA4pSA4pSA4pSA 4pSA4pSA4pSQDQo+IOKUgmNvbDEgICDilIINCj4g4pSc4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSk DQo+IOKUgnZhbGlkICDilILDnyBUaGlzIGlzIGNvcnJlY3QsIGFzIHRoYXQgZGF0ZSBzdHJpbmcg aXMgdmFsaWQgZGF0ZSBpbnB1dCBpbiANCj4gU3dlZGVuIOKUlOKUgOKUgOKUgOKUgOKUgOKUgOKU gOKUmA0KPiAoMSByb3cpDQo+ICANCj4gU28gaXMgdGhlIOKAmGlzIGluZ3Jlc2RhdGXigJkgcHJl ZGljYXRlIG9ubHkgcmVzcGVjdGluZyB0aGUgaW5zdGFsbGF0aW9uIHdpZGUgc2V0dGluZyBvZiBJ SV9EQVRFX0ZPUk1BVCBvciBpcyB0aGlzIGEgYnVnIGluIHRoZSBwcm9jZXNzaW5nPw0KPiAgDQo+ IE5vdGUgSeKAmXZlIHRyaWVkIHRoZSBhYm92ZSB1c2luZyB0aGUgc2V0IGRhdGVfZm9ybWF0IOKA mHN3ZWRlbuKAmSBjb21tYW5kIHdpdGggdGhlIHNhbWUgcmVzdWx0Lg0KPiAgDQo+IE1hcnRpbiBC b3dlcw0KPiBfX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fXw0K PiBJbmZvLWluZ3JlcyBtYWlsaW5nIGxpc3QNCj4gSW5mby1pbmdyZXNAbGlzdHMucGxhbmV0aW5n cmVzLm9yZw0KPiBodHRwczovL2xpc3RzLnBsYW5ldGluZ3Jlcy5vcmcvbWFpbG1hbi9saXN0aW5m by9pbmZvLWluZ3Jlcw0KDQo=

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

From Steve@21:1/5 to All on Wed Apr 14 20:30:21 2021

T24gVHVlc2RheSwgQXByaWwgNiwgMjAyMSBhdCA1OjI0OjEwIFBNIFVUQysxMCwgTWFydGluIEJv d2VzIHdyb3RlOg0KPiBIaSBBbGwsDQo+IEluIG15IGlubm9jZW5jZSBJIGFzc3VtZWQgdGhhdCB0 aGUg4oCYaXMgaW5ncmVzZGF0ZeKAmSBwcmVkaWNhdGUgd291bGQgd29yayB1c2luZyB0aGUgY3Vy cmVudCBzZXNzaW9uIHNldHRpbmcgb2YgSUlfREFURV9GT1JNQVQuIFRoYXQgdmFyaWFibGUgY2Fu IGFmdGVyIGFsbCBiZSBzZXQgbG9jYWxseSB0byBvdmVycmlkZSB0aGUgZ2xvYmFsIHNldHRpbmcg dXNlZCBpbiB0aGUgaW5zdGFsbGF0aW9uLiBHaXZlbiB0aGF0IG1hbnkgaW5wdXQgZGF0ZSBmb3Jt YXRzIGFyZSB2YWxpZCBpbiBzb21lIHNldHRpbmdzIGJ1dCBub3QgaW4gb3RoZXJzLCB1c2luZyB0 aGUgc2Vzc2lvbiBzZXR0aW5nIG1ha2VzIHNlbnNlIHRvIG1lLg0KPiBTbyBmb3IgZXhhbXBsZSBt eSBpbnN0YWxsYXRpb24gaGFzIElJX0RBVEVfRk9STUFUPW11bHRpbmF0aW9uYWw0LiBTbyB0b2Rh eXMgZGF0ZSB3b3VsZCBiZSBnZW5lcmF0ZWQgYXMg4oCYMDYvMDQvMjAyMeKAmQ0KPiBCdXTigKYN Cj4gRVhQT1JUIElJX0RBVEVfRk9STUFUPVNXRURFTg0KPiBzcWwgaWlkYmRiIDw8U1FMX0VORA0K PiBzZWxlY3QgZGJtc2luZm8o4oCYZGF0ZV9mb3JtYXTigJkpOw0KPiDilIzilIDilIDilIDilIDi lIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDi lIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDi lIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDi lIDilIDilIDilJANCj4g4pSCY29sMSDilIINCj4g4pSc4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA 4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA 4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA 4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSk DQo+IOKUgmZpbmxhbmQg4pSCDQo+IOKUlOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKU gOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKU gOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKU gOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUmA0KPiBzZWxl Y3QgZGF0ZSgndG9kYXknKVxnDQo+IOKUjOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKU gOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUkA0KPiDilIJjb2wx IOKUgg0KPiDilJzilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDi lIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilKQNCj4g4pSCMjAyMS0wNC0wNiDilIINCj4g 4pSU4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA 4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSYDQo+ICgxIHJvdykNCj4gc2VsZWN0IGNhc2Ugd2hlbiAn MjAyMS0wNC0wNicgaXMgaW5ncmVzZGF0ZSB0aGVuICd2YWxpZCcgZWxzZSAnaW52YWxpZCcgZW5k XGcNCj4g4pSM4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSQDQo+IOKUgmNvbDEg4pSCDQo+IOKUnOKU gOKUgOKUgOKUgOKUgOKUgOKUgOKUpA0KPiDilIJpbnZhbGlk4pSCIMOfIFdlbGwgdGhhdOKAmXMg YSBiaXQgb2YgYSBzaG9jay4NCj4g4pSU4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSYDQo+ICgxIHJv dykNCj4gc2VsZWN0IGNhc2Ugd2hlbiAnMDYvMDQvMjAyMScgaXMgaW5ncmVzZGF0ZSB0aGVuICd2 YWxpZCcgZWxzZSAnaW52YWxpZCcgZW5kDQo+IOKUjOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUkA0K PiDilIJjb2wxIOKUgg0KPiDilJzilIDilIDilIDilIDilIDilIDilIDilKQNCj4g4pSCdmFsaWQg 4pSCw58gVGhpcyBpcyBjb3JyZWN0LCBhcyB0aGF0IGRhdGUgc3RyaW5nIGlzIHZhbGlkIGRhdGUg aW5wdXQgaW4gU3dlZGVuDQo+IOKUlOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUmA0KPiAoMSByb3cp DQo+IFNvIGlzIHRoZSDigJhpcyBpbmdyZXNkYXRl4oCZIHByZWRpY2F0ZSBvbmx5IHJlc3BlY3Rp bmcgdGhlIGluc3RhbGxhdGlvbiB3aWRlIHNldHRpbmcgb2YgSUlfREFURV9GT1JNQVQgb3IgaXMg dGhpcyBhIGJ1ZyBpbiB0aGUgcHJvY2Vzc2luZz8NCj4gTm90ZSBJ4oCZdmUgdHJpZWQgdGhlIGFi b3ZlIHVzaW5nIHRoZSBzZXQgZGF0ZV9mb3JtYXQg4oCYc3dlZGVu4oCZIGNvbW1hbmQgd2l0aCB0 aGUgc2FtZSByZXN1bHQuIA0KPiBNYXJ0aW4gQm93ZXMNCg0KSGkgTWFydGluDQoNCkkgY2FuJ3Qg YW5zd2VyIHlvdXIgcXVlc3Rpb24sIGJ1dCB3aGVyZSBJIGN1cnJlbnRseSB3b3JrIGl0IGFsd2F5 cyB0YWtlIG1lIGEgY291cGxlIG9mIGdvZXMgdG8gZ2V0IHRoZSBkYXRlIGxpdGVyYWxzIHJpZ2h0 IHdoZW4gcnVubmluZyBhZGhvYyBxdWVyaWVzICh3aGljaCBJIHB1dCBkb3duIHRvIHVzZXIgZXJy b3IpLiBJIGRvbid0IHJlY2FsbCBoYXZpbmcgdGhpcyBwcm9ibGVtIGluIHRoZSBwYXN0IGFuZCB3 ZSdyZSBub3QgdXNpbmcgYW55dGhpbmcgYXMgZXhvdGljIGFzIFN3ZWRpc2ggb3IgRmlubmlzaCBk YXRlIGZvcm1hdHMuDQoNClN0ZXZlIA0KDQoNCiAg

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

Sysop:	Keyop
Location:	Huddersfield, West Yorkshire, UK
Users:	296
Nodes:	16 (2 / 14)
Uptime:	18:18:31
Calls:	6,646
Calls today:	1
Files:	12,190
Messages:	5,327,231

[Info-ingres] The 'is ingresdate' predicate and II_DATE_FORMAT

Who's Online

Recent Visitors

System Info