From: "M(dot) bischoff" <bischo03(at)ie(dot)hva(dot)nl>
To: pgsql-jdbc(at)postgresql(dot)org
Subject:
Date: 2003-06-13 03:49:38
Message-ID: 006c01c3315e$d0721490$1a01a8c0@ticker03
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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.

Browse pgsql-jdbc by date

  From Date Subject
Next Message Erik Price 2003-06-13 21:38:13 pg JDBC driver feature question
Previous Message Fernando Nasser 2003-06-11 22:24:56 Re: rsmd.getPrecision(i) + rsmd.isNullable(i)