|
Revision 9105, 422 bytes
(checked in by ebihara, 4 years ago)
|
TO_TIMESTAMP() の第一引数を text 型にキャストするよう修正
|
| Line | |
|---|
| 1 |
UPDATE c_image SET r_datetime = TO_TIMESTAMP(r_datetime::text, 'YYYY-MM-DD HH24:MI:SS') WHERE filename IN ('skin_no_image.gif', 'skin_no_logo.gif', 'skin_no_logo_small.gif', 'r_1_regular.gif', 'r_2_silver.gif', 'r_3_gold.gif', 'r_4_platinum.gif'); |
|---|
| 2 |
UPDATE c_member SET r_date = TO_TIMESTAMP(r_date::text, 'YYYY-MM-DD HH24:MI:SS'), u_datetime = TO_TIMESTAMP(u_datetime::text, 'YYYY-MM-DD HH24:MI:SS') WHERE c_member_id = 1; |
|---|