FreeTDS Development Group

["Steven J. Backus" <backus AT math.utah.edu>]

  Just noticed this (on sqsh 2.1 and freetds 0.53pre3).  Birth_date
is of type datetime:

111 episun12-> sqsh
Password: 
[21] episun7.ged.1> select birth_date from individual where id = 9743798
[21] episun7.ged.2> go
 birth_date         
 -------------------
 Dec 01 2023 06:28AM

(1 row affected)
[22] episun7.ged.1> 

Using sybase's isql (no freetds) the correct date shows up:

157 episun7-> isql
Password: 
[21] episun7.ged.1> select birth_date from individual where id = 9743798
[21] episun7.ged.2> go
 birth_date         
 -------------------
 Oct 25 1887 12:00AM

(1 row affected)
[22] episun7.ged.1> 

TDSDUMP follows:

2001-12-04 13:23:16 Connecting addr 155.100.158.47 port 4101
Sending packet @ 2001-12-04 13:23:16
0000  02 00 02 00 00 00 00 00 00 00 00 00 00 00 00 00   |................|
0010  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   |................|
0020  00 00 00 00 00 00 00 62 61 63 6b 75 73 00 00 00   |.......backus...|
0030  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   |................|
0040  00 00 00 00 00 06 73 61 6e 63 6c 61 6e 31 32 00   |......#########.|
0050  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   |................|
0060  00 00 00 00 09 33 37 38 37 36 00 00 00 00 00 00   |.....37876......|
0070  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   |................|
0080  00 00 00 05 03 01 06 0a 09 01 00 00 00 00 00 00   |................|
0090  00 00 00 00 73 71 73 68 00 00 00 00 00 00 00 00   |....sqsh........|
00a0  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   |................|
00b0  00 00 04 65 70 69 73 75 6e 37 00 00 00 00 00 00   |...episun7......|
00c0  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   |................|
00d0  00 07 00 09 73 61 6e 63 6c 61 6e 31 32 00 00 00   |....#########...|
00e0  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   |................|
00f0  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   |................|
0100  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   |................|
0110  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   |................|
0120  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   |................|
0130  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   |................|
0140  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   |................|
0150  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   |................|
0160  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   |................|
0170  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   |................|
0180  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   |................|
0190  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   |................|
01a0  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   |................|
01b0  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   |................|
01c0  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   |................|
01d0  00 0b 05 00 00 00 43 54 2d 4c 69 62 72 61 72 79   |......CT-Library|
01e0  0a 05 00 00 00 00 0d 11 00 00 00 00 00 00 00 00   |................|
01f0  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   |................|


Sending packet @ 2001-12-04 13:23:16
0000  02 01 00 5d 00 00 00 00 00 00 00 00 00 00 00 00   |...]............|
0010  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   |................|
0020  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   |................|
0030  00 00 00 00 00 00 00 00 00 00 00 00 01 30 00 00   |.............0..|
0040  00 00 00 01 00 00 00 00 e2 12 00 01 07 03 6d 7f   |..............m.|
0050  ff ff ff fe 02 07 00 00 0a 68 00 00 00            |.........h...|


2001-12-04 13:23:16 inside tds_process_login_tokens()
2001-12-04 13:23:16 inside tds_process_default_tokens() marker is e3
2001-12-04 13:23:16 inside tds_process_default_tokens() marker is e5
2001-12-04 13:23:16 Msg 5701, Level 10, State 2, Server episun7, Line 0
Changed database context to 'ged'.

2001-12-04 13:23:16 inside tds_process_default_tokens() marker is e3
2001-12-04 13:23:16 inside tds_process_default_tokens() marker is e2
2001-12-04 13:23:16 inside tds_process_default_tokens() marker is fd
2001-12-04 13:23:16 leaving tds_process_login_tokens() returning 1
2001-12-04 13:23:16 leaving ct_connect() returning 1
2001-12-04 13:23:24 inside ct_cmd_alloc()
2001-12-04 13:23:24 inside ct_command()
2001-12-04 13:23:24 inside ct_cmd_props()
2001-12-04 13:23:24 inside ct_send()
Sending packet @ 2001-12-04 13:23:24
0000  0f 01 00 43 00 00 00 00 21 36 00 00 00 00 73 65   |...C....!6....se|
0010  6c 65 63 74 20 62 69 72 74 68 5f 64 61 74 65 20   |lect birth_date |
0020  66 72 6f 6d 20 69 6e 64 69 76 69 64 75 61 6c 20   |from individual |
0030  77 68 65 72 65 20 69 64 20 3d 20 39 37 34 33 37   |where id = 97437|
0040  39 38 0a                                          |98.|


2001-12-04 13:23:24 inside ct_results()
2001-12-04 13:23:24 processing result tokens.  marker is  ee
2001-12-04 13:23:24 processing result tokens.  marker is  ae
2001-12-04 13:23:24 inside tds_process_default_tokens() marker is ae
2001-12-04 13:23:24 processing result tokens.  marker is  d1
2001-12-04 13:23:24 inside ct_res_info()
2001-12-04 13:23:24 inside ct_describe()
2001-12-04 13:23:24 inside _ct_get_client_type()
2001-12-04 13:23:24 inside ct_describe() datafmt->datatype = 6 server type 111
2001-12-04 13:23:24 inside _ct_get_server_type()
2001-12-04 13:23:24 inside _ct_get_server_type()
2001-12-04 13:23:24 inside _ct_get_server_type()
2001-12-04 13:23:24 inside _ct_get_server_type()
2001-12-04 13:23:24 inside _ct_get_server_type()
2001-12-04 13:23:24 inside _ct_get_server_type()
2001-12-04 13:23:24 inside _ct_get_server_type()
2001-12-04 13:23:24 inside _ct_get_server_type()
2001-12-04 13:23:24 inside _ct_get_server_type()
2001-12-04 13:23:24 inside _ct_get_server_type()
2001-12-04 13:23:24 inside _ct_get_server_type()
2001-12-04 13:23:24 inside _ct_get_server_type()
2001-12-04 13:23:24 inside _ct_get_server_type()
2001-12-04 13:23:24 inside _ct_get_server_type()
2001-12-04 13:23:24 inside _ct_get_server_type()
2001-12-04 13:23:24 inside _ct_get_server_type()
2001-12-04 13:23:24 inside _ct_get_server_type()
2001-12-04 13:23:24 inside _ct_get_server_type()
2001-12-04 13:23:24 inside _ct_get_server_type()
2001-12-04 13:23:24 inside _ct_get_server_type()
2001-12-04 13:23:24 inside _ct_get_server_type()
2001-12-04 13:23:24 inside _ct_get_server_type()
2001-12-04 13:23:24 inside _ct_get_server_type()
2001-12-04 13:23:24 inside _ct_get_server_type()
2001-12-04 13:23:24 inside _ct_get_server_type()
2001-12-04 13:23:24 inside _ct_get_server_type()
2001-12-04 13:23:24 inside _ct_get_server_type()
2001-12-04 13:23:24 inside _ct_get_server_type()
2001-12-04 13:23:24 inside _ct_get_server_type()
2001-12-04 13:23:24 inside _ct_get_server_type()
2001-12-04 13:23:24 inside _ct_get_server_type()
2001-12-04 13:23:24 inside _ct_get_server_type()
2001-12-04 13:23:24 inside _ct_get_server_type()
2001-12-04 13:23:24 inside _ct_get_server_type()
2001-12-04 13:23:24 inside _ct_get_server_type()
2001-12-04 13:23:24 inside _ct_get_server_type()
2001-12-04 13:23:24 inside _ct_get_server_type()
2001-12-04 13:23:24 inside _ct_get_server_type()
2001-12-04 13:23:24 inside _ct_get_server_type()
2001-12-04 13:23:24 inside _ct_get_server_type()
2001-12-04 13:23:24 inside _ct_get_server_type()
2001-12-04 13:23:24 inside _ct_get_server_type()
2001-12-04 13:23:24 inside _ct_get_server_type()
2001-12-04 13:23:24 inside _ct_get_server_type()
2001-12-04 13:23:24 inside _ct_get_server_type()
2001-12-04 13:23:24 inside _ct_get_server_type()
2001-12-04 13:23:24 inside _ct_get_server_type()
2001-12-04 13:23:24 inside _ct_get_server_type()
2001-12-04 13:23:24 inside ct_bind()
2001-12-04 13:23:24 inside ct_bind() item = 1 datafmt->datatype = 6
2001-12-04 13:23:24 inside ct_fetch()
2001-12-04 13:23:24 processing row tokens.  marker is  d1
2001-12-04 13:23:24 setting column 0 to NULL
2001-12-04 13:23:24 inside _ct_bind_data()
2001-12-04 13:23:24 inside _ct_get_server_type()
2001-12-04 13:23:24 inside _ct_bind_data() converting column 0 from type 111 
to type 61
2001-12-04 13:23:24 inside _ct_bind_data() setting source length for 0 = 8
2001-12-04 13:23:24 inside _ct_bind_data() conversion done len = 8 bindfmt = 0
2001-12-04 13:23:24 inside _ct_bind_data() length binding len = 8
2001-12-04 13:23:24 inside _ct_get_server_type()
2001-12-04 13:23:24 inside _ct_get_server_type()
2001-12-04 13:23:24 inside ct_fetch()
2001-12-04 13:23:24 processing row tokens.  marker is  fd
2001-12-04 13:23:24 inside ct_results()
2001-12-04 13:23:24 inside ct_res_info()
2001-12-04 13:23:24 inside ct_results()
2001-12-04 13:23:24 inside ct_cmd_drop()
2001-12-04 13:23:25 inside ct_con_props() action = 25 property = 26
2001-12-04 13:23:25 inside ct_close()
2001-12-04 13:23:25 inside ct_con_drop()
2001-12-04 13:23:25 inside ct_exit()