Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
daniel-dhl01
Starting Member
1 Post |
 Posted - 2010-05-20 : 05:35:00
|
| Hello,iam new on this forum so i don't know if this is the right topic.Question is can run "alter session set nls_date_format = 'DAY DD MON YYYY HH24:MI:S" wihtin a other query runnin in Query reporter.I like to combine this query to set time with a query wich is comming from a oracle database.This is the script i want to combine with the alter sessionselect srs_id rule_, srs_coo Lvo, srs_car_id Carrier, srs_sty_id Ship_type, srs_shipment_type Shipment_type, srs_customer_id Cust_id, srs_cus_status D_V, --to_char(srs_cut_off_day) Day_Of_Week, substr(srs_cut_off_day,1,10) Day_Of_Week, substr(srs_cut_off_time,22,16) Time_, substr(srs_pickup_day,1,10) Pick_up_day, Substr(srs_pickup_time,22,16) Pick_up_time from jim_shipment_rulesDaniel |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
|
|
|
|
|
|
|
alter session