select  

DATEDIFF('SECOND', PARSEDATETIME('19700101000000', 'yyyyMMddHHmmss'), DATETIME_COLUMN   )

 FROM TABLE_NAME

import com.fasterxml.jackson.core.JsonGenerationException;

import com.fasterxml.jackson.databind.JsonMappingException;

import com.fasterxml.jackson.databind.ObjectMapper;

import com.fasterxml.jackson.databind.SerializationFeature;

...

....

....

public static String getJSON(Map<?, ?> map) throws JsonGenerationException, JsonMappingException, IOException

{

if (map == null ) return null;

ObjectMapper mapper = new ObjectMapper();

// pretty format

mapper.configure(SerializationFeature.INDENT_OUTPUT, true);

StringWriter sw = new StringWriter();

mapper.writeValue(sw, map);

return sw.toString();

}

[04/02/2013 10:28:33] Evernote 4.6.4.8136 Installation has started

[04/02/2013 10:28:33] Running as user: Administrator

[04/02/2013 10:28:33] Initializing installed product finder.

[04/02/2013 10:28:33] Checking if product {f761359c-9ced-45ae-9a51-9d6605cd55c4} is installed.

[04/02/2013 10:28:33] Product {f761359c-9ced-45ae-9a51-9d6605cd55c4} is not installed.

[04/02/2013 10:28:33] Checking registry for product {f761359c-9ced-45ae-9a51-9d6605cd55c4}.

[04/02/2013 10:28:33] Product GUID {f761359c-9ced-45ae-9a51-9d6605cd55c4} was not found in the registry

[04/02/2013 10:28:33] Initializing installed product finder.

[04/02/2013 10:28:33] Located product {4C8BBCC8-8363-11E2-A3F4-984BE15F174E} with upgrade code {AE2C091E-CF5F-4e30-8659-D640E23A8B99}.

[04/02/2013 10:28:33] Error getting product version: 1605

[04/02/2013 10:28:33] Error getting product install location: 1605

[04/02/2013 10:28:33] Initializing installed product finder.

[04/02/2013 10:28:33] Checking if product {A5C8B875-E86C-4783-83F4-F35E788FFC29} is installed.

[04/02/2013 10:28:33] Product {A5C8B875-E86C-4783-83F4-F35E788FFC29} is not installed.

[04/02/2013 10:28:33] Checking registry for product {A5C8B875-E86C-4783-83F4-F35E788FFC29}.

[04/02/2013 10:28:33] Product GUID {A5C8B875-E86C-4783-83F4-F35E788FFC29} was not found in the registry

[04/02/2013 10:28:33] Checking for already installed products

[04/02/2013 10:28:33] Detected version  installation

[04/02/2013 10:28:33] Installed version () did not support admin check. Attempting to use MsiEnumProductsEx.

[04/02/2013 10:28:33] PerUser install by another user: abort.

mwtech(playok):/home/playok/nforge4/play-2.1.0> git clone https://github.com/nforge/nforge4.git

Cloning into nforge4...

error: SSL certificate problem, verify that the CA cert is OK. Details:

error:14090086:SSL routines:SSL3_GET_SERVER_CERTIFICATE:certificate verify failed while accessing https://github.com/nforge/nforge4.git/info/refs

fatal: HTTP request failed

mwtech(playok):/home/playok/nforge4/play-2.1.0> 

mwtech(playok):/home/playok/nforge4/play-2.1.0> env GIT_SSL_NO_VERIFY=true git clone https://github.com/nforge/nforge4.git

Cloning into nforge4...

remote: Counting objects: 11306, done.

remote: Compressing objects: 100% (3212/3212), done.

remote: Total 11306 (delta 8358), reused 10900 (delta 7953)

Receiving objects: 100% (11306/11306), 3.39 MiB | 605 KiB/s, done.

"%VISUALSVN_SERVER%\bin\VisualSVNServerHooks.exe" ^

    commit-notification "%1" -r %2 ^

    --from 보내는메일 --to 수신메일주소 ^

    --smtp-server SMTP서버주소 ^ 

    --smtp-user 접속계정 ^

    --smtp-password 접속비밀번호 ^

    --smtp-port 587 ^

    --no-diffs

com.google.android.gcm.server.InvalidRequestException: HTTP Status Code: 401

at com.google.android.gcm.server.Sender.sendNoRetry(Sender.java:177)

at com.google.android.gcm.server.Sender.send(Sender.java:121)

at com.google.android.gcm.demo.server.SendAllMessagesServlet.doPost(SendAllMessagesServlet.java:82)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:641)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)

at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:929)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:405)

at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:964)

at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:515)

at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:302)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)

at java.lang.Thread.run(Thread.java:722)

(mx.messaging.messages::ErrorMessage)#0

  body = (null)

  clientId = "78D874E7-B468-4E2C-B7B9-8C5002EC82E4"

  correlationId = "13A47B44-3C30-59A0-6DF2-4C4611C5E210"

  destination = "WonderFulWorld1"

  extendedData = (null)

  faultCode = "Server.Processing"

  faultDetail = (null)

  faultString = "java.lang.NoClassDefFoundError : Could not initialize class com.mybatis.SqlSessionManager"

  headers = (Object)#1

  messageId = "3637160E-3F0A-10C3-09AA-3BC4369F455B"

  rootCause = (Object)#2

    cause = (null)

    localizedMessage = "Could not initialize class com.mybatis.SqlSessionManager"

    message = "Could not initialize class com.mybatis.SqlSessionManager"

  timestamp = 1358489326511

  timeToLive = 0

DAUMURL  := "http://air21.daum.net/air21/widget/sendMessage.daum?"  ; 수신 URL

SENDER := "ME" ; 보낸 사람
MYPEOPLEKEY := "z4*****************"  ; 마이피플의 키

HttpGetRequest("안녕하세요")

HttpGetRequest(MSG){
 global Timeouts
 global DAUMURL, SENDER, MYPEOPLEKEY

 SENDMSG := DAUMURL
  . "key="
  . MYPEOPLEKEY
  . "&from="
  . SENDER
  . "&content="
  . MSG

 HTTP := ComObjCreate("WinHttp.WinHttpRequest.5.1")
 HTTP.Open("GET", SENDMSG, False)
 HTTP.SetRequestHeader("User-Agent", "Internet Explorer 9")
HTTP.SetTimeouts(Timeouts*)
 HTTP.Send()
 if (HTTP.Status != 200)
  return OnError(HTTP.Status, HTTP.ResponseText)
 return HTTP.ResponseText
}
 
OnError(Status, String){
 MsgBox % String
 return ""
}

<?xml version="1.0" encoding="utf-8"?>

<s:TabbedViewNavigatorApplication xmlns:fx="http://ns.adobe.com/mxml/2009" 

 xmlns:s="library://ns.adobe.com/flex/spark" applicationDPI="160">

<fx:Style>

@namespace s "library://ns.adobe.com/flex/spark";

@font-face {

src: url("NanumGothic.otf");

fontFamily: "NaNumGothic_CFF";

embedAsCFF: true;

}

@font-face {

src: url("NanumGothic.otf");

fontFamily: "NaNumGothic";

embedAsCFF: false;

}

s|Application

{

embedFonts: true; 

fontWeight: normal; 

fontFamily: NaNumGothic;

}

s|ViewNavigator{ 

embedFonts: true; 

fontWeight: normal; 

fontFamily: NaNumGothic; 

}

s|RichText {

embedFonts: true; 

fontWeight: normal; 

fontFamily: NaNumGothic_CFF;

}

</fx:Style>

<s:ViewNavigator label="목록" width="100%" height="100%" firstView="views.ListView" fontFamily="NaNumGothic"/>

<s:ViewNavigator label="보기" width="100%" height="100%" firstView="views.View"/>

<s:ViewNavigator label="설정" width="100%" height="100%" firstView="views.SettingView"/>

<fx:Declarations>

<!-- Place non-visual elements (e.g., services, value objects) here -->

</fx:Declarations>

</s:TabbedViewNavigatorApplication>

http://www.microsoft.com/ko-kr/download/details.aspx?id=17718

db2set DB2_COMPATIBILITY_VECTOR=ORA

db2stop

db2start

DECODE(컬럼,'값','값2') AS 컬럼 

SELECT
    DECODE(cond, '1','일이다1123878798798791', '2', '기타') || NAME
FROM (
SELECT '1' AS COND, '정' AS name FROM DUAL
union
SELECT '2' AS COND, '김' AS name FROM DUAL
)

  public static void Logger( String receiverKey, String fromName, String msg)

{

StringBuffer sb = new StringBuffer();

try {

sb.append("key=");

sb.append( receiverKey );

sb.append("&from=");

sb.append( fromName );

sb.append("&");

sb.append("content");

sb.append("=");

sb.append(URLEncoder.encode( msg , "UTF-8" ) );

URL url = new URL("http://air21.daum.net/air21/widget/sendMessage.daum");

URLConnection conn = url.openConnection();

conn.setDoOutput(true);

OutputStreamWriter wr = new OutputStreamWriter(conn.getOutputStream());

wr.write(sb.toString());

wr.flush();

BufferedReader rd = new BufferedReader(new InputStreamReader(conn.getInputStream()));

String line = null;

while ((line= rd.readLine() ) != null) {

System.out.println(line);

}

wr.close();

rd.close();

} catch (UnsupportedEncodingException e) {

e.printStackTrace();

} catch (MalformedURLException e) {

e.printStackTrace();

} catch (IOException e) {

e.printStackTrace();

}

}