Return date as ddmmyyyy in SQL Server -

-

i need date ddmmyyyy without spacers.

how can this?

i can yyyymmdd using convert(varchar, [mydatetime], 112)

but need reverse of this.

sql server 2008

convert style 103 dd/mm/yyyy. use replace function eliminate slashes.

select replace(convert(char(10), [mydatetime], 103), '/', '')

Comments

Post a Comment

Popular posts from this blog

javascript - Iterate over array and calculate average values of array-parts -

-
i have array this: ["2011-06-16 16:37:20",23.2], ["2011-06-21 16:37:20",35.6], ["2011-06-26 16:37:20",41.8], ["2011-07-01 16:37:20",25], ["2011-07-06 16:37:20",22.8], ["2011-07-11 16:37:20",36.4], ["2011-07-16 16:37:20",34], ["2011-07-21 16:37:20",20] [...] format: [$date,count] now need add 3rd 4th value every array element, average of n counts before or after. example if n=3 the 3rd value should average of 3 count-values before , 4th value should average of 3 count-values after current array element. result that: ["2011-06-16 16:37:20",23.2, null, 34.13], ["2011-06-21 16:37:20",35.6, null, 29.86], ["2011-06-26 16:37:20",41.8, null, 28.06], ["2011-07-01 16:37:20",25, 33.53, 31.06], ["2011-07-06 16:37:20",22.8, 34.13, 30.13], ["2011-07-11 16:37:20",36.4, 29.86, null], ["2011-07-16 16:37:20",34, 28.06, null], ["2...
Read more

php - Time zone issue -

-
what going on when time on server out 12 hours? working on site friend, , noticed although server in our timezone, 12 hours behind when writing records db. did checks so: <?php echo(gmstrftime("it %a on %b %d, %y, %x time zone: %z",time())); phpinfo(); ?> result: it thu on jul 21, 2011, 04:46:46 time zone: gmt ... date date/time support enabled "olson" timezone database version 2010.15 timezone database internal default timezone pacific/auckland directive local value master value date.default_latitude 31.7667 31.7667 date.default_longitude 35.2333 35.2333 date.sunrise_zenit 90.583333 90.583333 date.sunset_zenith 90.583333 90.583333 date.timezone pacific/auckland pacific/auckland ask can see, php reports 4:46 am. it's 4:46pm here. reports gmt timezone, phpinfo reports pacific/auckland timezone (gmt+12). i asked webhost going on. weren't sure, system's time correct. , there no other php.ini files being introduced. ide...
Read more

php - How can I edit my code to echo the data of child's element where my search term was found in, in XMLReader? -

-
i new in xmlreader, , think kind of hard find tutorials/code or advanced examples. question how can transform code have now, if search (through form) term jquery give me opportunity output value of <info></info> (and later other elements) in every <name></name> found in ? this code output names of books. <?php $reader = new xmlreader(); $reader->open("books.xml"); while ($reader->read()) { switch ($reader->nodetype) { case (xmlreader::element): if ($reader->localname == "name") { $reader->read(); echo $reader->value; break; }}} ?> the xml file <?xml version="1.0" encoding="iso-8859-1"?> <library> <book isbn="781"> <name>scjp 1.5</name> <info>sun certified java programmer book</info> </book> <bo...
Read more