sql server - Convert SQL datetime to specific format -

-

मेरे पास एक तालिका है datetime नीचे के रूप में colomn:

< tbTest 

  ID पूर्णांक सेटडेट डेटेट करें   
 और एक प्रविष्टि जैसे:  
  आईडी सेटडेट 1 04/10/2014 02:38:16 PM   
 मैं SetDate को  डीडी-एमएम-याय एचएच: मिमी: एसएस पीएम  या  में परिवर्तित करना चाहता हूं डीडी-एमएम-yyyy hh: मिमी PM   
 वांछित आउटपुट:  <प्री>  आईडी सेट डेट 1 10-04-2014 2:38:16 PM   
 या  
  1 10-04-2014 2:38 अपराह्न    
 
 
 आप  कनवर्ट   
  का उपयोग कर सकते हैं कन्वर्ट (varchar (10), getdate (), 105) + '' + SUBSTRING (कन्वर्ट (varchar, getdate (), 100), 14, 4) + '' राइट (कन्वर्ट (varchar, getdate (), 100), 2)    / html>

Comments

Post a Comment

Popular posts from this blog

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

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

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