.....
.....
char sDate[24];
EXEC SQL Select to_char(date,'YYYY-MM-DD HH24:MI:SS') Into :sDate From dual;
printf("sDate=%s\n",sDate);
.....
char sDate[24];
EXEC SQL Select to_char(date,'YYYY-MM-DD HH24:MI:SS') Into :sDate From dual;
printf("sDate=%s\n",sDate);
char sDate[24];
EXEC SQL Select to_char(birthday,'YYYY-MM-DD HH24:MI:SS') Into :sDate From dual;
printf("sDate=%s\n", birthday);
# include <stdio.h>
EXEC SQL BEGIN DECLARE SECTION;
char EMPFNAME[100];
char EMPLNAME[100];
char SEX;
char BIRTH[24];
EXEC SQL END DECLARE SECTION;main()
{
int i=0;
db_init( &sqlca );
EXEC SQL WHENEVER SQLERROR GOTO error;
EXEC SQL CONNECT "dba" IDENTIFIED BY "sql";
EXEC SQL DECLARE emp CURSOR FOR
SELECT emp_fname,emp_lname,sex,to_char(birth_date,'YYYY-MM-DD HH24:MI:SS')
FROM employee;
EXEC SQL OPEN emp;
for( ; ; )
{
EXEC SQL WHENEVER NOT FOUND GOTO UN;
EXEC SQL FETCH emp INTO :EMPFNAME,:EMPLNAME,:SEX,:BIRTH;
printf("%s %s %c %s\n",EMPFNAME,EMPLNAME,SEX,BIRTH);
}
EXEC SQL CLOSE emp;
EXEC SQL COMMIT WORK;
EXEC SQL DISCONNECT;
db_fini( &sqlca );
return( 0 );
error:
printf( "SECLECT FAILED -- sqlcode = %ld.n",
sqlca.sqlcode );
return( -1 );
UN:
printf("over");
}
v_Date date;
begin
select sysdate into v_Date from dual;
end;