Forum › Internet Service & Networking › How to convert varchar to datetime in php? database type is MSSQL?

isms Publish time 4-9-2012 11:05 AM

How to convert varchar to datetime in php? database type is MSSQL?

Salam,

nak tanya,
mcm mana sy nak convert data dari format varchar ke date dlm php. Database yg sy gunakan adalah ms sql. yg sy google kebanyyakkannya pakai mysql.

cth, ktlah field tarikh varchar , field name = TARIKHSTR, so sy nak convert ker field date, field name = TARIKH,
mcm mana rupe coding n sintak dia dlm php ?format date tuh dd/mm/yyyy

anyone can help?

Last edited by isms on 4-9-2012 11:20 AM

chuki2 Publish time 4-9-2012 01:06 PM

Kenapa field pada table tak pakai type datetime?

isms Publish time 4-9-2012 02:46 PM

chuki2 posted on 4-9-2012 01:06 PM static/image/common/back.gif
Kenapa field pada table tak pakai type datetime?

saya pun x tahu sbb apa bos sy pakai varchar sebelum ne

alam. Publish time 4-9-2012 02:52 PM

kalau ms sql ... format date.. store by default = ("MM/dd/yyyy")..
bukan "dd/mm/yyyy"
contoh dlm .net..

dim YourDate as new date
YourDate = CDate(date.now.tostring)
insert into (columndate) VALUES (YourDate.tostring("MM/dd/yyyy"))

dlm php xtahu...

chuki2 Publish time 5-9-2012 11:42 AM

Kalau dalam C# saya buat macam ini sahaja..DateTime enteredDate = DateTime.Parse(enteredString);

nalis Publish time 6-9-2012 08:45 AM

Kompius aku dgn soklan ko nih..

Kalau ikut pemahaman aku, ko nak copy value dari field TARIKHSTR (varchar) ke field TARIKH (datetime).. betul mcm tu?? Kalau nak buat camtu, tak perlu pun PHP.. CUma run query je kat MSSQL tu

katakanlah ko punya database bernama AYAM dan nama table adalah ITIKset dateformat dmy
use AYAM
update ITIK
set TARIKH = CAST(TARIKHSTR AS DATETIME)p/s: kod tu aku tak test pun.. cuba la dulu

isms Publish time 6-9-2012 09:07 AM

nalis posted on 6-9-2012 08:45 AM static/image/common/back.gif
Kompius aku dgn soklan ko nih..

Kalau ikut pemahaman aku, ko nak copy value dari field TARIKHSTR...

heehee sorry, mebi ayat tunggang langgang
tp citernya lebih kurang gtu ler..

sbb database simpan date dlm varchar,
bila sy nak guna sql statement 'BETWEEN' antara 2 tarikh, cth : dari 1/1/2012 hingga 1/12/2012, field tarikh kena dalam btk datetime, sbb tuh ler sy nak convert field varchar ke datetime.

sy punya coding pakai php, sbb tuh ler tanya mcm2 tuh, ingat nak bg org paham, pakai programming langguange per, database per...heheh sorry,
anyway thanks, akan dicuba

isms Publish time 6-9-2012 09:10 AM

nalis posted on 6-9-2012 08:45 AM static/image/common/back.gif
Kompius aku dgn soklan ko nih..

Kalau ikut pemahaman aku, ko nak copy value dari field TARIKHSTR...
pesal yg ko ckp run guery kt mssql tuh kan...
aku x nak ubah apa2 kt database, meaning biarlah filed tarikh tuh menten as varchar

cuma aku nak convert ms wat coding kt php
sbb tuh aku nak convert kt php coding


coding ne, kalau aku run kt mssql, akan ubah aku nyer dbase kan?

nalis Publish time 6-9-2012 09:14 AM

isms posted on 6-9-2012 09:10 AM static/image/common/back.gif
pesal yg ko ckp run guery kt mssql tuh kan...
aku x nak ubah apa2 kt database, meaning biarlah fi ...

rasanya ko ni merujuk kepada permasalah ko yg aritu kan? cuba rujuk jawapan aku ritu http://mforum.cari.com.my/forum.php?mod=redirect&goto=findpost&ptid=670074&pid=49975234&fromuid=1085642

isms Publish time 6-9-2012 09:44 AM

nalis posted on 6-9-2012 09:14 AM static/image/common/back.gif
rasanya ko ni merujuk kepada permasalah ko yg aritu kan? cuba rujuk jawapan aku ritu http://mforum ...

oh ok, thanks, x perasan ada reply kt thread tuh

View full version: How to convert varchar to datetime in php? database type is MSSQL?