oracle - Convert time stored as hh24miss to hh24:mi:ss -

-

I have a column in my table that will store time as hh24miss format, i.e. it 091315 < / Code> which is 9 minutes 13 minutes and 15 seconds, I need to convert it to HH 24: MI: SS and insert it with date column which is in the format YYYYMMDD . Just, the following column dates: 19940601 and time: 091315 to 01-Jan-94 09:13:15 .

You should not store dates in the form of stars, and time There is no need to store in a separate field. The second involves the time below (you need TIMESTAMP for seconds frames.)

If you are actually stuck with this schema, then you have two strings A DATE : 

  to_date (date_column || time_column, 'YYYYMMDDHH24MISS')   
 Then you can show that you Whatever format you want; Which you have shown:  
  to_char (to_date (date_column || time_column, 'YYYYMMDDHH24MISS'), 'DD-Mon-RR HH 24: MI: SS')   
 However, you have data on June, no.  
  
 But in fact, please re-use your schema again and use the appropriate data type, do not store the value as a star, you have no validity and there is no easy way to check that the value you submitted Really represent the valid date and time.

Comments

Post a Comment

Popular posts from this blog

Pygame memory leak with transform.flip -

-
Today I came across an interesting issue which, by writing a small side scroller, instead of a sprite sheet, I was planning to use because I lacked a good "packer" for making phantom sheets (and honestly with patience and passion as it is only a test project). Anyway, I showed the animation running on the right of 8 PNG (with transparency). I considered it a good idea to prepare the flipped images to run on the left in the consultant, and the frame is not framed when the game is running (Flip actually consumes a lot of CPU like I Was measured). > To get access to the loop, I get the memory leak self.move_l = [# 8 PNG images with transparency to the right] For the self in IMG. Move_l: self.move_r.append (pygame.transform.flip (img, true, false) error traceback: traceback (most recent Call final): The file "D: \ Python 34 \ _Projects \ efg \ efg.py", in line 196, in the & lt; module & gt; main = master program ((1024, 680)) "D: \ Python ...
Read more

python - Writing Greek in matplotlib labels, titles -

-
Image
I'm trying to write some text for labels, shape titles etc. with my plots, but no benefit till now Has not happened . I do not want to print specific characters (I know how to use special characters), I want to write the entire text in Greek (maybe Unicode and text ' ?). , suggesting that I would like to mention that for some reason I can not get matplotlib to cooperate with Tex (using IPython notebook from Anaconda in Ubuntu 14.10) so that there really is an option Will not be the first. I tried loading the Arial font and it loads successfully but again I get square blocks instead of characters. I import matplotlib.font_manager FM PROP = FM Font Properties (fname = '/ usr / share / fonts / truetype / msttcorefonts / Arial.ttf') And then to display the string I u'Î? ? I ?? Î¿Ï ?? ÎμÎ »second ?? μΠ± i ?? I ± i ?? I ?? Used ο किया? ? Î¿Î¼Î¿Î¯Ï ?? I ?? I · I ?? ' . Ariel is considered to be fully presented to Greek and I have used it many times ...
Read more

cmake set_source_files_properties not working properly -

-
I have a project in which. C is a group of files which need to be compiled as C files, but I need it to be compiled as C ++ code. I tried the solution I found, but did not work as expected. Instead of making filename.c only, it is compiled as C ++, it compiles all the files in my project as C ++ code. Without that call, all the files have been compiled as C. I also tried: set_source_files_properties ($ {FILES_SRC} property languages ​​C) set_source_files_properties (filename.c property languages ​​CFX) Where FILES_SRC variable keeps all my source files. I am CMK 2.8.12 and Visual Studio 11 ARM Generator. Any ideas how can I fix this? I finished compiling the library using C compiler and added a C ++ code to a different library For which I created a C interface so it can be told from my C library.
Read more