Date field wont display completely

Results 1 to 2 of 2

Thread: Date field wont display completely

  1. #1
    Manpreet Guest

    Default Date field wont display completely

    i have a field which is of the type "datetime" in sql server 6.5.<BR>Now when i use the in built query tool in sql server it shows the complete date like "Jul 21 1999 12:10 am"<BR><BR>However when i query it thro ASP it shows the same in mm/dd/yy format. I tried usin gthe "FormatDate" function in vbscript but that doesnot help. I want the date to be displayed as it is in the database..<BR><BR>any clues???<BR>

  2. #2
    Join Date
    Dec 1969
    Posts
    2,849

    Default RE: Date field wont display completely

    I strongly recommend you check out Dan&#039s Custom Date Formatting Script, available at:<BR><BR>http://www.4guysfromrolla.com/webtech/112098-2.shtml<BR><BR>It allows you to display a date in just about any format you choose! :) Happy Programming!

Posting Permissions

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