Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. GoneAccessCrazy

    Only the date in a datetime

    Thanks for your help... the format stuff worked in Java with 'dd/MM/yyyy' instead of "dd/MM/yyyy"... I'm dumb or what!!! Again, thanks for all GAC
  2. GoneAccessCrazy

    Only the date in a datetime

    I'm connecting with the default JDBC-ODBC bridge in JDK1.3.1 something like this... Class.forName(sDriver); System.out.println("Opening db connection"); connection = DriverManager.getConnection(sUrlBD, sUser, sPassword); where sDriver=sun.jdbc.odbc.JdbcOdbcDriver and...
  3. GoneAccessCrazy

    Only the date in a datetime

    Hmmmm, that works inside Access, but not in my Java application, do you know something else? this query SELECT Usuario.Login, Format([FechaHoraSesion],"dd/MM/yyyy") AS Fecha, Format([FechaHoraSesion],"hh:mm:ss") AS Hora...
  4. GoneAccessCrazy

    Only the date in a datetime

    Is there a way to select only the date of a datetime column, I was using the left(date1,10) but when the system date format is other that MM/dd/yyyy y end up getting part of the time. e.g. Select left(date1,10) as dateBegin, right(date1,8) AS hourBegin ... when date is MM/dd/yyyy I get...
  5. GoneAccessCrazy

    putting a 0 when something is null (empty)

    Hey, thanks a lot!!!! ... (not crazy anymore, at least for now ;D) GAC
  6. GoneAccessCrazy

    putting a 0 when something is null (empty)

    Hi, I dunno if this thing is possible... I first have 2 queries and their results... ****QueryRent: SELECT Cliente.IdCliente, Cliente.Nombre, Cliente.ApePat, Cliente.ApeMat, Sum(Alquiler.MontoTPagado) AS MontoPagadoA, Cliente.MontoDeuda FROM Cliente INNER JOIN Alquiler ON Cliente.IdCliente =...

Part and Inventory Search

Back
Top