Date format in ASP

Results 1 to 2 of 2

Thread: Date format in ASP

  1. #1
    Join Date
    Dec 1969

    Default Date format in ASP

    Hi! The output of a date filed from SQL is in mm/dd/yyyy format. I would like to convert that output to DDMMMYYYY format. Is there any easy solution for that?<BR><BR>I am currently using the following statement: Convert(varchar(10),fieldname,103) which converts it to DDMMYYYY. However, I need the month field to be MMM instead.<BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Date format in VBScript

    ASP isn&#039;t a language. you&#039;re thinking of VBScript. actually, SQL Server dates are stored in an internal format and only APPEAR to be stored the way you say. look into the FormatDateTime() function to get a different format.<BR><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