Report
Question
select to_char(sysdate,’HH24:MI:SS’) from dual; select to_char(sysdate,’YYY MM DD’) from dual; The SYSDATE pseudo-column shows the current system date and time. Adding 1 to SYSDATE will advance the date by 1 day. Use fractions to add hours, minutes or seconds to the ...

Please briefly explain why you feel this question should be reported .

Report
Cancel
0
9 months 0 Answers 2 views

Report
Question
Oracle Select * FROM table_name WHERE to_char(TRIP_TIMESTAMP, ‘Month’) = to_char(sysdate, ‘Month’) select * from SL_GAME delete from SL_GAME where game_id = 10 commit; Select * FROM table_name WHERE to_char(TRIP_TIMESTAMP, ‘Month’) = to_char(add_months(TRUNC(SYSDATE) + 1, 11), ‘Month’) — Return and comparision of November month Select * FROM table_name

Please briefly explain why you feel this question should be reported .

Report
Cancel
0
9 months 0 Answers 2 views

Report
Question
1st approach: sudo launchctl start com.edb.launchd.postgresql-9.2 sudo launchctl stop com.edb.launchd.postgresql-9.2 2nd approach: get the data store location (e.g. /Library/PostgreSQL/9.2/data) from /Library/LaunchDaemons/com.edb.launchd.postgresql-9.2.plist su postgres cd /Library/PostgreSQL/9.2/bin/ ./pg_ctl -D /Library/PostgreSQL/9.2/data/ start ./pg_ctl -D /Library/PostgreSQL/9.2/data/ stop  

Please briefly explain why you feel this question should be reported .

Report
Cancel
0
10 months 0 Answers 11 views