Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    12

    Cool Unanswered: Converting datetime in a string

    Hi there,

    Can anyone help?

    I am trying to convert datetime into a string in the following format


    2003-10-09 13:23:15.967



    Current syntax:



    SELECT '"' + CAST(t.Stamp AS varchar(30)) + '"' AS 'Start'


    Any one any ideas?



    THANKYOU!!!!

    Melanie

  2. #2
    Join Date
    Jul 2002
    Location
    Village, MD
    Posts
    621
    Try this:

    select convert(varchar,getdate(),121)

Posting Permissions

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