Postgres Pro
Downloads
Home   >   mailing lists

- Mailing list pgsql-jdbc

From M. bischoff
Subject
Date
Msg-id 006c01c3315e$d0721490$1a01a8c0@ticker03
Whole thread Raw
List pgsql-jdbc
Tree view
Dear Postgre JDBC support,
 
I have a question,
 
after reading true the documentation I was unable to find out how to get the server time true the JDBC,
I also tried getting it by pulling it out of the driver but it leaves an empty string:
 
<code>
metaData = connection.getMetaData();
String SQLKeywords = metaData.getSQLKeywords();
System.out.println("SQLKeywords: "+SQLKeywords);
String stringFunctions = metaData.getStringFunctions();
System.out.println("stringFunctions: "+stringFunctions);
String systemFunctions = metaData.getSystemFunctions();
System.out.println("systemFunctions: "+systemFunctions);
String timeDateFunctions = metaData.getTimeDateFunctions();
System.out.println("timeDateFunctions: "+timeDateFunctions);
</code>

SQLKeywords: abort,acl,add,aggregate,append,archive,arch_store,backward,binary,change,cluster,copy,database,delimiter,delimiters,do,extend,explain,forward,heavy,index,inherits,isnull,light,listen,load,merge,nothing,notify,notnull,oids,purge,rename,replace,retrieve,returns,rule,recipe,setof,stdin,stdout,store,vacuum,verbose,version

stringFunctions:

systemFunctions:

timeDateFunctions:

I don't want to get the current time by getting the local system tiem cuz that may be incorrect.

please help,

Michael Bischoff.

pgsql-jdbc by date:

Previous
From: Erik Price
Date:
Subject: Re: pg JDBC driver feature question
Next
From: Kris Jurka
Date:
Subject: Re: pg JDBC driver feature question