Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- int rtoday(long *today) {
- EXEC SQL BEGIN DECLARE SECTION;
- time_t t;
- EXEC SQL END DECLARE SECTION;
- EXEC SQL WHENEVER SQLERROR DO sql_error("Oracle errorn");
- EXEC SQL CONNECT :"user/pass@dbname";
- EXEC SQL SELECT (new_time(sysdate,'EDT','GMT') - to_date('31-dec-1899','dd-mon-yyyy')) INTO :t FROM DUAL;
- printf( "C Time = %dn", time(NULL) );
- printf( "SQL Time = %dn", t );
- *today=t;
- }
Add Comment
Please, Sign In to add comment