sql server - best way to get iso into usa format -

-

trying convert date string usa format

'20150316 16:28' '3/16/2015 4:28 pm'

(note: 24hr format fine too)

http://sqlfiddle.com/#!6/9eecb/862

the predefined format "g" give date time in format:

select format(cast('20150316 16:20' datetime), 'g')

update:

select format( cast('20150316 16:20' datetime), 'd')  + ' ' + format( cast('20150316 16:20' datetime), 'hh:mm')

produces 3/16/2015 16:20

see these articles predefined , custom date time formats:

https://msdn.microsoft.com/en-us/library/8kb3ddd4(v=vs.110).aspx

https://msdn.microsoft.com/en-us/library/az4se3k1(v=vs.110).aspx

note these vary culture.


Comments

Post a Comment

Popular posts from this blog

node.js - Mongoose: Cast to ObjectId failed for value on newly created object after setting the value -

-
this question has answer here: what's mongoose error cast objectid failed value xxx @ path “_id”? 7 answers even though has been asked many times because entity has no valid objectid field. i came across situation objectid set value can casted objectid still error. the schema: var serviceschema = parammongoose.schema({ servicename:{ type: parammongoose.schema.types.objectid , ref: 'servicenames',required:true } }); pseudo code: servicefromdb=new service({servicename:'some name'}); servicefromdb.servicename='000000000000000000000001'; servicefromdb.save(function(paramerror,paramdata){ if(paramerror){ console.log('but but...',servicefromdb,paramerror) } }); the output of code is: but but... { servicename: 000000000000000000000001, _id: 55079a90286f49280364f78b } { [casterror: cast objectid faile...
Read more

[C++][SFML 2.2] Strange Performance Issues - Moving Mouse Lowers CPU Usage -

-
i've been working on making 2d map editor past 2 weeks or so, , i've run strange problem. trying optimize code, example, making functions should've been functions begin with, did made cpu usage go through roof. i've tried commenting out different sections of code thought culprits (scrolling, rendering, other calculations) no avail. think issue might trying call things within different functions, sake of making modular possible, i'd functionality. the other major change i've made since file i'm comparing i've ported variables external cpp file, since having variables global makes lot easier use within different functions. simple issue, can't life of me understand why happens. with original code, around 2-3% cpu usage. new code, around 20-35%, but, if move mouse around, it'll drop around 6-8%. tl;dr: after trying optimize code using functions, i've somehow killed performance, , found strange quirk moving mouse reduces cpu usage.. /...
Read more

javascript - React + webpack: 'process.env' is undefined -

-
Image
i'm trying run hot dev server on our site webpack; site uses reactjs, has code in it: if (\"production\" !== process.env.node_env) // etc when not running hot-swap it's fine, hot-swap, gets run, resulting in error: typeerror: process.env undefined the code looks this: the project modelled after https://github.com/webpack/react-starter does work; question is; error have made in config file and/or how go looking error when 'production' compilation works fine? i've posted gist of webpack config file . in webpack config, there 2 options can affect process.env : when specify config.target (see config.target ) when define process.env variable via defineplugin looking @ code, looks process.env might undefined when both options.prerender , options.minimize false . you fix using environment defines process.env (ex: node ), or using defineplugin assign default value variable yourself.
Read more