Drop leading zero in date format

[bird0]

Has anybody tried to drop the leading zeros in the date format? I am thinking
writing a procedure or a VB function to do it. But I suspect there should
be an easier way to do it in one SQL statement. Maybe there is some built
in functions that I don't know that can do it really easy.

Any advice or hints will be appreciated.


Bird0

[Steve Jackson]

Isn't there a format function where you can specify the format you
want? This is probably easy - hopefully someone here know off
the top of their head. Are you using SQL Server? If you want to
use a function in SQL, it has to be supported by the DBMS, so
it helps to be specific about which you are using.

Steve Jackson

On 22 Aug 2000 10:22:44 -0700, "bird0" <bird0@yahoo.com> wrote:

>
>Has anybody tried to drop the leading zeros in the date format? I am thinking
>writing a procedure or a VB function to do it. But I suspect there should
>be an easier way to do it in one SQL statement. Maybe there is some built
>in functions that I don't know that can do it really easy.
>
>Any advice or hints will be appreciated.
>
>
>Bird0


Steve Jackson, Enterprise Section Leader
stephenjackson@compuserve.com