Thread:

From
"M. bischoff"
Date:
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.