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!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
"Easy" SQL query
Hello, I've created the query: SELECT "Clients"."Out" FROM "Clients" LEFT OUTER JOIN "Clients interested" ON "Clients"."Id" = "Clients interested"."Id" WHERE "Clients interested"."Out" = 0 It...- INTLuis
- Thread
- Replies: 1
- Forum: PostgreSQL Inc.: PostgreSQL
-
updating years in PostgreSQL
I need to update a date field (the date, not the hour) in postgreSQL to another year. In Access it's so simple as : UPDATE historiales SET historiales.hora = CDate(Format([fecha], "dd/mm/yyyy") + " " + Format([hora], "hh:mm:ss")) WHERE (((Year([hora])) = 1899))...- INTLuis
- Thread
- Replies: 2
- Forum: PostgreSQL Inc.: PostgreSQL
