3/07/2007

SQL: modify date type

SCOTT@HUIYI>select sysdate from dual;

SYSDATE
----------
13-1月 -07

SCOTT@HUIYI>alter session set nls_date_format = 'yyyy-mm-dd hh24:mi:ss';

已更改階段作業.

SCOTT@HUIYI>select sysdate from dual;

SYSDATE
-------------------
2007-01-13 13:31:06

SCOTT@HUIYI>select to_char(sysdate,'Day') from dual;

TO_CHA
------
星期六

-- 轉換中指定
SCOTT@HUIYI>select to_char(sysdate,'Day','nls_date_language=american') from dual;

TO_CHAR(S
---------
Saturday

SCOTT@HUIYI>

-- 更改SESSION
SCOTT@HUIYI>alter session set nls_date_language=american;

已更改階段作業.

SCOTT@HUIYI>select to_char(sysdate,'Day') from dual;

TO_CHAR(S
---------
Saturday

SCOTT@HUIYI>alter session set nls_date_language='simplified chinese';

已更改階段作業.

SCOTT@HUIYI>select to_char(sysdate,'Day') from dual;

TO_CHA
------
星期六

SCOTT@HUIYI>alter session set nls_date_language='TRADITIONAL CHINESE';

已更改階段作業.

SCOTT@HUIYI>select to_char(sysdate,'Day') from dual;

TO_CHA
------
星期六

SCOTT@HUIYI>

SCOTT@HUIYI>alter session set nls_date_language=american;

已更改階段作業.

SCOTT@HUIYI>select to_char(sysdate,'Day') from dual;

TO_CHAR(S
---------
Saturday

SCOTT@HUIYI>select to_char(sysdate,'Day','nls_date_language=''TRADITIONAL CHINESE''') from dual;

TO_CHA
------
星期六

3/06/2007

A Derby Week?

Today,some important matches will start at AM3:45.These are InterMilan against Valencia,Liverpool against Barcelona and so on.~~ Solo Inter!Fozza Inter!
In my mind the follow squad should be inter's squad in tonight:
Cesar

Grosso Materlazzi Cordoba Maicon

Maxwell Dacourt Zanetti

Stankovic

Crespo Ibrahimovic

++++++++++++U,my inter!!!!

3/04/2007

Happy The Lantern Festval or Yuanxiao Jie

Today is the lantern festval,i 'll going out for dinner with a mm~~~~lol,happy the lantern festval~~The follow paragraph can describe Chinese Lantern Festival :
The Lantern Festival or Yuanxiao Jie is a traditional Chinese festival, which is on the 15th of the first month of the Chinese New Year. The festival marks the end of the celebrations of the Chinese New Year.
Chinese started to celebrate the Lantern Festival from the Han Dynasty (206 BC - 221 AD). Like most other Chinese festivals, there is also a story behind the Festival. It is also believed that the festival has Taoist origins.
This is a festival for people having fun. On the night of the festival, people go on streets with a variety of lanterns under the full moon, watching lions or dragon dancing, playing Chinese riddles and games, and lighting up firecrackers. There is really a lot of fun for the young and the old. The festival is not well celebrated in the US, though you may find celebrations in some Chinese communities, such as Hsi Lai Temple, Hacienda Heights, California.
Yuanxiao (glutinous rice ball) or Tangyuan is the special food for the Lantern Festival. It is believed that Yuanxiao is named after a palace maid, Yuanxiao, of Emperor Wu Di of the Han Dynasty. Yuanxiao is a kind of sweet dumpling, which is made with sticky rice flour filled with sweet stuffing. And the festival is named after the famous dumpling. Yuanxiao is sticky, sweet and round in shape, symbolizing family unity, completeness and happiness.
You can find Yuanxiao in oriental food stores. If you enjoy cooking, here is a recipe of Yuanxiao for you.
Ingredients
4 1/2 cups (500 g) sticky rice flour butter 7 oz (200 g) black sesame powder 7 oz (200 g) sugar 8 oz (250 g) 1 tsp wine
Methods
1. Mix the butter with sesame powder, sugar and wine together. You need to heat a little bit. Make small balls about 0.3-0.4 oz (10 g) each. 2. Take 1/2 cup of sticky rice flour. Add water into the flour and make a flatten dough. Cook it in boiled water and take out until done. Let it cool down. Then put it in the rest of the sticky rice flour. Add water and knead until the dough is smooth. 3. Make the dough into small pieces about 0.3-0.4 oz (10 g) each. Make it like a ball using hands first and then make a hole in the ball like a snail. Put the sesame ball into it and close it up. 4. Cook them in boiled water. Make sure to keep stirring in one direction while cooking. When they float on the water, continue to boil for about one minute using less heat.

3/02/2007

new blog~~

update to final edition~~congratulation~