Results 1 to 2 of 2

Thread: Date Format

  1. #1
    Join Date
    Aug 2002
    Location
    BH - MG - BRAZIL
    Posts
    13

    Unanswered: Date Format

    Hi!!!

    My procedure get a date using the function getdate() and insert in the datetime field.
    I.e. 04/04/03 09:55:18
    I would like format my data without time.

    Excuse me my simple english.

    Thank you.

  2. #2
    Join Date
    Jul 2001
    Location
    Germany
    Posts
    189

    Hello

    Hello,

    you use Oracle I guess ????

    For Oracle use TRUNC(datefield) to TRUNCate the time value.

    Hope that helps ?

    Manfred Peter
    (Alligator Company GmbH)
    http://www.alligatorsql.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
  •