sql - Perl and Oracle DB - help -


i using oracle express database, , know how can change date formatting- dd-mm-yyyy dd-mm-yyyy hh-mm. also, i've heard alter session, don't know how use in perl.

this did far:

my $sth = $dbh->prepare("insert perl                             (a_field,b_field,c_field,time_stame)                           values                             (?,?,?,to_date(?,'dd/mm/yyyy hh24:mi'))");

date fields in oracle not formatted display - it's internal format convert to/from on input/output. when store date in oracle date datatype columns, convert character string internal format describing date-time to_date function format model string. oracle interprets character string it's internal format. when need display date, reverse - tell oracle how display date again giving format model, time to_char function.

to illustrate example, convert dd-mm-yyyy dd-mm-yyyy hh-mm without ever storing value (i assume meant display hours-minutes. format model minutes 'mi', since 'mm' month):

sql> select to_char(to_date('01-01-2020','dd-mm-yyyy'),'dd-mm-yyyy hh-mi') mydate       dual;  mydate ---------------- 01-01-2020 12-00

note example, time portion of date not supplied on input, defaults midnight. store time value in date column, must supply time value in input:

sql> select to_char(to_date('01/01/2020 10:13','dd/mm/yyyy hh:mi'),'dd-mm-yyyy hh-mi') mydate         dual;  mydate ---------------- 01-01-2020 10-13  sql>

depending on you're trying do, system date in oracle can obtained reference pseudo-column sysdate:

sql> select to_char(sysdate,'mm/dd/yyyy hh:mi:ss am') dt1,   2         to_char(sysdate,'dd-mon-yyyy hh24:mi:ss') dt2   3    dual;  dt1                    dt2 ---------------------- ----------------------------- 07/01/2011 03:44:30 pm 01-jul-2011 15:44:30  sql>

so roundabout answer question entirely depends on format input date string in. convert oracle's date type via format model , to_date function, convert date item display format of choosing via to_char , format model. "alter session" command alluded in question, can specify default format model date conversions specifying nls_date_format parameter in alter session command:

sql> select sysdate dual;  sysdate --------- 02-jul-11  sql> alter session set nls_date_format='dd-mon-yyyy hh24:mi:ss';  session altered.  sql> select sysdate dual;  sysdate -------------------- 02-jul-2011 10:39:24

Comments

Post a Comment

Popular posts from this blog

c# - SharpSVN - How to get the previous revision? -

i trying find efficient way previous revision of file text comparison using sharpsvn. using (svnclient c = new svnclient()) { c.authentication.defaultcredentials = new networkcredential( configurationmanager.appsettings.get("svnserviceusername") , configurationmanager.appsettings.get("svnservicepassword") , configurationmanager.appsettings.get("svnservicedomain") ); c.authentication.sslservertrusthandlers += new eventhandler<svnsslservertrusteventargs>(authentication_sslservertrusthandlers); collection<svnfileversioneventargs> fileversioncollection = new collection<svnfileversioneventargs>(); svnrevisionrange range = new svnrevisionrange(0, this.hooks.revision); svnfileversionsargs args = new svnfileversionsargs(); args.retrieveproperties = true; args.range = range; foreach (svnchangeitem item in log.changedpaths) { string path = this.repositorypath + it...
Read more

c++ - Is it possible to compile a VST on linux? -

for class project i'm attempting write vst plugin backed cuda. current cuda workflow on linux box, i'd prefer compile , link there. according wikipedia , should possible (i couldn't find steinberg documentation relevant linux) can't find makefile or instructions on how build if aren't using xcode or visual studio. i'm vst 3 sdk doesn't support linux. when try compile plugin under linux, error: ./base/source/fatomic.cpp:39:30: fatal error: libkern/osatomic.h: no such file or directory this issue caused following code in "vst3 sdk/base/source/fatomic.cpp" #if mac #include <libkern/osatomic.h> #if mac_os_x_version_min_required > mac_os_x_version_10_4 #define native_atomic_type (volatile int32_t*) #else #define native_atomic_type (int32_t*) #endif #elif windows #include <windows.h> #endif but hope compiling under linux work vst sdk 2.4. reading. jvstwrapper seems run on lin...
Read more

url - Querystring manipulation of email Address in PHP -

i using third party application (email2http) send me emailid, body , message. unable retrieve email id due name appended on , enclosed < , >. here querystring getting. test.php?from=ajay+reddy &subject=cx&body=somebody when print variable in php returns name , not email id. $from = $_get['from']; echo $from; //output ajay reddy please suggest me how can emailid also. i dont want use post method due testing , debugging. it's working fine. forgot use htmlentities() in debugging.
Read more