sql - Oracle: Convert Full Date to a Different Date Format -

-

in oracle database,i have column of type varchar2 in table has entry this:

wednesday, august 3, 2016 12:00:00 cest

i wish convert 08-03-2016

i have tried use to_date followed to_char fails. guidance helpful.

try one:

select      to_timestamp(         regexp_substr('wednesday, august 3, 2016 12:00:00 cest',             '\w+ +\d+, \d{4} \d{2}:\d{2}:\d{2} (a|p)m'),          'fmmonth dd, fmyyyy hh:mi:ss am')  dual;

resp. 

select to_char(     to_timestamp(         regexp_substr('wednesday, august 3, 2016 12:00:00 cest',             '\w+ +\d+, \d{4} \d{2}:\d{2}:\d{2} (a|p)m'),          'fmmonth dd, fmyyyy hh:mi:ss am'),      'mm-dd-yyyy') dual;

in case need day no time information had luck, because cest ambiguous, see this:

select tzabbrev, tz_offset(tzname), tzname v$timezone_names tzabbrev = 'cest' order 2;  tzabbrev tz_offset(tzname)  tzname ======== ================== ============ cest    +01:00  africa/algiers cest    +01:00  europe/lisbon cest    +01:00  portugal cest    +02:00  atlantic/jan_mayen cest    +02:00  cet cest    +02:00  europe/amsterdam cest    +02:00  europe/belgrade cest    +02:00  europe/berlin cest    +02:00  europe/bratislava cest    +02:00  europe/brussels cest    +02:00  europe/budapest cest    +02:00  europe/copenhagen cest    +02:00  europe/gibraltar cest    +02:00  arctic/longyearbyen cest    +02:00  africa/tunis cest    +02:00  africa/tripoli cest    +02:00  africa/ceuta cest    +02:00  poland cest    +02:00  libya cest    +02:00  europe/zurich cest    +02:00  europe/zagreb cest    +02:00  europe/warsaw cest    +02:00  europe/vienna cest    +02:00  europe/vatican cest    +02:00  europe/tirane cest    +02:00  europe/ljubljana cest    +02:00  europe/luxembourg cest    +02:00  europe/madrid cest    +02:00  europe/monaco cest    +02:00  europe/oslo cest    +02:00  europe/paris cest    +02:00  europe/podgorica cest    +02:00  europe/prague cest    +02:00  europe/rome cest    +02:00  europe/san_marino cest    +02:00  europe/sarajevo cest    +02:00  europe/skopje cest    +02:00  europe/stockholm cest    +03:00  europe/zaporozhye cest    +03:00  europe/tallinn cest    +03:00  europe/vilnius cest    +03:00  europe/minsk cest    +03:00  europe/kaliningrad cest    +03:00  europe/sofia cest    +03:00  europe/uzhgorod cest    +03:00  europe/athens cest    +03:00  europe/riga

thus not trivial determine correct time zone.


Comments

Post a Comment

Popular posts from this blog

magento2 - Magento 2 admin grid add filter to collection -

-
i created grid in admin xml ui components. need filter collection via url parameter , dont know how achieve that. tried inject requestinterface collection, filter didnt work. di.xml <virtualtype name="slidelistingdataprovider" type="magento\framework\view\element\uicomponent\dataprovider\dataprovider"> <arguments> <argument name="collection" xsi:type="object" shared="false">xxx\xxx\model\resourcemodel\grid\slide\collection</argument> <argument name="filterpool" xsi:type="object" shared="false">slidelistingfilterpool</argument> <!-- define new object filters --> </arguments> </virtualtype> <virtualtype name="slidelistingfilterpool" type="magento\framework\view\element\uicomponent\dataprovider\filterpool"> <arguments> <argument name="applier...
Read more

Android volley - avoid multiple requests of the same kind to the server? -

-
i using volley upload list of images server. happens within service. once image uploaded remove list. problem arises when internet connection breaks. when internet connection breaks , comes again thinking of adding images yet uploaded request queue. this can result in more 1 copy of same image saved on server request same image might have gone through before getting rseponse. how can address scenario? i'm not quite sure why you're using service schedule requests volley automatically runs it's request in seperate thread. nevertheless can listen both request results, successful , unsuccessful adding listeners. you can remove image list schedule request using volley. if succeeds can carry on desired, if fails can add again list. public static request getimageuploadrequest(final string image) { response.listener<t> responselistener = new response.listener<t>() { @override public void onresponse(t response...
Read more

Combining PHP Registration and Login into one class with multiple functions in one PHP file -

-
i'm trying combine registration, activation , login scripts php website backend script front end developer can pass variables different forms to. my question whether appropriate approach this. don't want have lot of php files different pieces of application developing. far have written following 2 functions login, register , activate user front end developer can call: <?php /** * created phpstorm. * user: karl * date: 26/07/2016 * time: 02:25 */ class users { function register_user($email, $password, $user_name) { $server_name = "localhost"; $u_name = "root"; $db_password = "root"; $db_name = "betamath_graspe"; //email notification variable $from_address="info@slack.com"; //registration form $msg_reg_user='username taken. please choose different username'; $msg_reg_email='email registered'; $msg_reg_active=...
Read more