Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Get Qt Extensions
  • Unsolved
Collapse
Brand Logo
  1. Home
  2. Qt Development
  3. General and Desktop
  4. Qt 5.1.1 - QSqlQuery not return a correct QDateTime
Qt 6.11 is out! See what's new in the release blog

Qt 5.1.1 - QSqlQuery not return a correct QDateTime

Scheduled Pinned Locked Moved General and Desktop
2 Posts 2 Posters 1.7k Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • E Offline
    E Offline
    estanisgeyer
    wrote on last edited by
    #1

    Hi,

    I'm using Qt5.1.1 on Kubuntu 13.04.
    I'm trying to return a database firebird, the current date and time. This code has worked in Qt 4.8, but Qt5.1.1 not functional, see the code snippet:

    @
    QSqlQuery q;
    q.exec(" SELECT CURRENT_TIMESTAMP FROM RDB$DATABASE ");
    q.next();

    qDebug() << q.value(0);
    @

    In output (see the time):
    QVariant(QDateTime, QDateTime("qui ago 29 00:00:00 2013") )

    Marcelo Estanislau Geyer
    Standard Net Tecnologia / Brazil

    1 Reply Last reply
    0
    • SGaistS Offline
      SGaistS Offline
      SGaist
      Lifetime Qt Champion
      wrote on last edited by
      #2

      Hi and welcome to devnet,

      Could it be that the date is localized to you system settings ?

      Interested in AI ? www.idiap.ch
      Please read the Qt Code of Conduct - https://forum.qt.io/topic/113070/qt-code-of-conduct

      1 Reply Last reply
      0

      • Login

      • Login or register to search.
      • First post
        Last post
      0
      • Categories
      • Recent
      • Tags
      • Popular
      • Users
      • Groups
      • Search
      • Get Qt Extensions
      • Unsolved