Results 1 to 3 of 3

Thread: space in sql value is replaced by letter T

  1. #1
    Join Date
    Sep 2010
    Posts
    10
    Thanks
    2
    Qt products
    Qt4
    Platforms
    Unix/X11
    Wiki edits
    1

    Default space in sql value is replaced by letter T

    Well, a strange problem.
    I've managed to execute several sql commands against the database, but when selecting a timestamp for the first time, I get 2010-09-25T11:11:11. Notice the letter T. Where did that come from? (Qt 4.6, ubuntu, postgresql 8.4.4)
    Any ideas on what this might be or how to get rid of it?

    The same query executed directly in sql client gives me the correct value.

    Could it be some clever replacement of a tab?

  2. #2
    Join Date
    Jan 2006
    Location
    Belgium
    Posts
    1,938
    Thanked 268 Times in 268 Posts
    Qt products
    Qt4
    Platforms
    Unix/X11 Windows
    Wiki edits
    20

    Default Re: space in sql value is replaced by letter T


  3. The following user says thank you to tbscope for this useful post:

    Gunnar (25th September 2010)

  4. #3
    Join Date
    Sep 2010
    Posts
    10
    Thanks
    2
    Qt products
    Qt4
    Platforms
    Unix/X11
    Wiki edits
    1

    Default Re: space in sql value is replaced by letter T

    Then it must be a feature!

    Solved the problem by using QDateTime::fromString() and QDateTime::toString().
    Thank you!

Similar Threads

  1. Qt Creator Custom widget plugin being replaced with parent class
    By mhill in forum Qt Tools
    Replies: 0
    Last Post: 28th July 2010, 18:58
  2. How to get the Drive letter
    By newb in forum Qt Programming
    Replies: 10
    Last Post: 10th June 2010, 13:59
  3. Shourtcut for letter
    By swrer in forum Qt Programming
    Replies: 2
    Last Post: 9th March 2010, 10:29
  4. Replies: 1
    Last Post: 26th July 2009, 15:08
  5. linking user space and kernel space programs with qmake
    By zielchri in forum Qt Programming
    Replies: 9
    Last Post: 8th March 2006, 23:11

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Digia, Qt and their respective logos are trademarks of Digia Plc in Finland and/or other countries worldwide.