Drop leading zero in date format


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Drop leading zero in date format

  1. #1
    bird0 Guest

    Drop leading zero in date format


    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

  2. #2
    Steve Jackson Guest

    Re: Drop leading zero in date format


    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center