format time

Results 1 to 2 of 2

Thread: format time

  1. #1
    Join Date
    Dec 1969

    Default format time

    in asp to get time you do:<BR>now() which brings up time in this format "1/23/2002 6:43:30 PM"<BR><BR>how would i bring up the date? like this "1/23/2002"<BR><BR>also how would i do a query to search for all the values created today?<BR>strSQL = "SELECT * FROM table Where time_created = today"<BR>Set RS = Conn.Execute(strSQL)<BR><BR>if u understand please help :)

  2. #2
    Join Date
    Dec 1969

    Default actually, FormatDateTime()

    try looking it up<BR><BR><BR><BR>(a polite RTFM)<BR><BR>j<BR>

Posting Permissions

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