DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: edit mask for time

  1. #1
    hammam Guest

    edit mask for time


    hi
    i have field it's type smalldatetime in SQLserver 7
    i want save time in this field i'm using edit mask control with mask "##:##"
    to save in time format when i retrive this field i got stange date in this

    so any one know i can save time field send to me
    thanks,


  2. #2
    Michael Cole Guest

    Re: edit mask for time

    hammam,

    Try:-
    before saving, field = CDate(meb1).
    After reading, meb1 = Format$(field, "hh:nn")

    HTH


    --
    Regards,

    Michael D. Cole
    Mercury Computer Systems
    http://www.mercsys.com.au

    "hammam" <mhdhamam@hotmail.com> wrote in message
    news:39098756$1@news.devx.com...
    >
    > hi
    > i have field it's type smalldatetime in SQLserver 7
    > i want save time in this field i'm using edit mask control with mask

    "##:##"
    > to save in time format when i retrive this field i got stange date in this
    >
    > so any one know i can save time field send to me
    > thanks,
    >




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