sql server - To add offset with the UTC date in SQL -

-

dates in database(sql) in utc. want dates based on timezone. example if it's ist (utc+05:30) want ist date , time in database. if knows, please guide me operation in database (i have date , offset of particular timezone).

you've tagged sql server 2008 able use datetimeoffset.


Comments

Post a Comment

Popular posts from this blog

php - how to give proper permission for pcntl_exec? -

-
i trying fork php script , execute php script using pcntl_exec command, getting following error: pcntl_exec(): error has occured: (errno 13) permission denied i trying following code after normal forking in function: $pathtofile="/var/www/html"; $outputfile =array("mytestfile.php"); if ($pid) // parent { $pid_arr[$i] = $pid; } else // child { pcntl_exec($cmd,$outputfile); return "error occurred in child"; } all other pcntl functions working properly, tried chmod , chown commands on directory well, still pcntl_exec not working. please tell me doing wrong? thanks in advance!! try option: chmod 755 /var/www/html this should grant permission needed!
Read more

javascript - Feed FileReader from server side files -

-
i´m starting customize/improve old audio editor project. can import audio tracks canvas via drag&drop computer. thing use audio tracks stored in server clicking on list of available tracks... instead of use <input type="file"> tags. how can read server side files filereader?ajax perhaps? in advance. this code file reader: player.prototype.loadfile = function(file, el) { //console.log(file); var reader = new filereader, filetypes = ['audio/mpeg', 'audio/mp3', 'audio/wave', 'audio/wav'], = this; if (filetypes.indexof(file.type) < 0) { throw('unsupported file format!'); } reader.onloadend = function(e) { if (e.target.readystate == filereader.done) { // done == 2 $('.progress').children().width('100%'); var onsuccess = function(audiobuffer) { $(el).trigger('audiee:fileloaded', [audiobuffer, file]); ...
Read more

c++ - What's the differece between of link to a dynamic file and as a input object? -

-
i use g++ link project (an executable mono_kitti) , project dependent on thirdparty library pangolin. when link action -lpangolin option: g++ -l../../lib -lorb_slam2 -lpangolin mono_kitti.o -o mono_kitti it returns: mono_kitti.o:(.data+0x0): undefined reference `vtable pangolin::handler' mono_kitti.o:(.data+0x8): undefined reference `vtable pangolin::handlerscroll' mono_kitti.o: in function `pangolin::handler::~handler()': mono_kitti.cc:(.text._zn8pangolin7handlerd2ev[_zn8pangolin7handlerd5ev]+0x13): undefined reference `vtable pangolin::handler' mono_kitti.o: in function `pangolin::handlerscroll::~handlerscroll()': mono_kitti.cc:(.text._zn8pangolin13handlerscrolld2ev[_zn8pangolin13handlerscrolld5ev]+0x13): undefined reference `vtable pangolin::handlerscroll' collect2: error: ld returned 1 exit status but when use command: g++ -l../../lib -lorb_slam2 mono_kitti.o /usr/local/lib/libpangolin.so -o mono_kitti it succeeded. but failed again when tr...
Read more