cat > script <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'
create table testtime (time time);
insert into testtime set time to '21 September 1983 14:22:07';
insert testtime set to '13 Aug 1984 2:17:44';
insert into testtime set to '8 Jul 58 12:12:12';
insert into testtime set to '8 Jul 84 12:12:12';
insert testtime set time 'November 11 1983 9:30:31';
insert testtime set time 'November 1983 9:30:31';
select from testtime;
+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 755 script
cat > stdout <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'
* * * * 
*** Error: conversion error for attribute 'time': value '8 Jul 58 12:12:12'
invalid year
* * 
*** Error: conversion error for attribute 'time': value 'November 11 1983 9:30:31'
invalid day
* 
*** Error: conversion error for attribute 'time': value 'November 1983 9:30:31'
invalid day
*           time

19830921142207
19840813021744
19840708121212
* 
+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 644 stdout
cat > tag <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'
Testing the time datatype
+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 644 tag
cat > stdout.jp_euc <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'
* * * * 
*** Error: Ѵ顼 ȥӥ塼 'time':  '8 Jul 58 12:12:12' 
աǯˤλ꤬㤤ޤ
* * 
*** Error: Ѵ顼 ȥӥ塼 'time':  'November 11 1983 9:30:31' 
աˤλ꤬㤤ޤ
* 
*** Error: Ѵ顼 ȥӥ塼 'time':  'November 1983 9:30:31' 
աˤλ꤬㤤ޤ
*           time

19830921142207
19840813021744
19840708121212
* 
+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 644 stdout.jp_euc
