datetime prob

Results 1 to 2 of 2

Thread: datetime prob

  1. #1
    cheril Guest

    Default datetime prob

    I am inserting a record in the Db where 1 column will contain datetime which I insert using &#039Now&#039<BR>Then when I am retreiving this value from the DB I want only the date to display, so I&#039ve given it as <BR>&#060;%=mid(rs1("redate"),1,8)%&#062;<BR>The above works when date is 12/23/00 but it gives the 1st character of time also when date is 1/2/01(now 6 charaacters only)<BR>How do I solve this problem.<BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: datetime prob

    Try using:<BR><BR> datevalue(rs1("redate"))<BR><BR>Check the docs (link on the left) for more info.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts