[Firebird-devel] [ firebird-Bugs-518343 ] isql's addrow mangles date input

[<no...@so...>]

Bugs item #518343, was opened at 2002-02-16 00:06
You can respond by visiting: 
http://sourceforge.net/tracker/?func=detail&atid=109028&aid=518343&group_id=9028

Category: ISQL
Group: Confirmed Bug
Status: Open
Resolution: None
Priority: 5
Submitted By: Claudio Valderrama C. (robocop)
Assigned to: Nobody/Anonymous (nobody)
Summary: isql's addrow mangles date input

Initial Comment:
isql has a debug-only feature called addrow that was 
enabled by Firebird on the prod version, too. 
Currently, it allows to add a row, field by field to a 
table, in an interactive, command-line way. The 
problem is that for date fields, it uses the tm 
struct, but the implementor forgot that in tm, the 
year is 1900 based, hence we get a shift:

SQL> create table t(d timestamp);
SQL> add t;
Enter data or NULL for each column.  RETURN to end.
Enter D as M/D/Y>1/1/2002
Enter D as M/D/Y>
Bad date

SQL> select * from t;

                        D
=========================
3902-01-01 00:00:00.0000


----------------------------------------------------------------------

You can respond by visiting: 
http://sourceforge.net/tracker/?func=detail&atid=109028&aid=518343&group_id=9028