If anyone can help

Results 1 to 2 of 2

Thread: If anyone can help

  1. #1
    Join Date
    Dec 1969

    Default If anyone can help

    Here is the scenario<BR><BR>I have a table on an SQL database that has a date field set to getDate(). The data type is It is collecting the time correctly in the database but when I try to display the field it will not display the seconds. It keeps displaying 00 for seconds. I have tried setting the field to datetime but that does not work either.<BR><BR>Many people trying to convert the field to with the formatDateTime function or creating a Stored Proc and using a TSQL convert function but that shouldn&#039;t make a difference.<BR>I have used datetime and smalldatetime since the day I was born and never had this problem. It should just display as is with correct seconds.<BR><BR>If anyone has had this happen to them please advise.<BR><BR><BR>Stanley

  2. #2
    EF Guest

    Default RE: If anyone can help


Posting Permissions

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