Simple but driving me crazy!

Results 1 to 3 of 3

Thread: Simple but driving me crazy!

  1. #1
    Charlotte Guest

    Default Simple but driving me crazy!

    I have a Sql database containing a smalldatatime field, so for example my data would contain: 21/05/2001 14:45:00<BR><BR>I am trying to display this data in a more user firendly way in a select box, the format i would like is: 21 May 2001 - 2.45pm<BR><BR>My main problem is returning the time, is there no function to return a 24hr date in my preferred format?<BR><BR>- this is driving me mad!!<BR><BR>Thanks<BR>Charlotte

  2. #2
    Join Date
    Dec 1969

    Default RE: Simple but driving me crazy!

    Use the FormatDateTime() function but with that you are limiteded to general, short and long date. If that does not serve your purpose, you may need to write you date format function.

  3. #3
    New ASP"6553500 259741259651"07/23/01 22:14:18 Guest

    Default RE: Simple but driving me crazy!

    &#060;%@ Language=VBScript %&#062;<BR>&#060;%<BR><BR>test = "21/05/2001 14:45:00"<BR><BR>Response.Write FormatDateTime(test, 1) & " " & FormatDateTime(test, 3)<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