sybperl-l Archive
Up Prev Next
From: "David LANDGREN" <dlandgre at bpinet dot com>
Subject: Re: Differences in convert()ed AM/PM times
Date: Jan 23 2002 5:42PM
|BTW - you can also use the following:
|
|[21] ecircles_plum.qa: 1> select convert(varchar, getdate(), 109)
|[21] ecircles_plum.qa: 2> go
|
| ------------------------------
| Jan 23 2002 8:28:21:396AM
|
|(1 row affected)
|
|i.e. not specify the width of the varchar column - it gets sized
|appropriately (at least on 11.9.x and later - I don't have an 11.5
|running on which to test at short notice)
Indeed, "Jan 23 2002 6:38:29:186PM " on Sybase 11.5
Thanks,
David
|
