Forum

Date Format in ASP (2) - Από {manrj}

Exo to parakato Query:

select * from tableName where start_date >=#01/01/2004# and start_date < #02/01/2004# order by start_date

Auto fernei oles tis egrafes tou Ianouariou
Doulevi mia xara oxi omos kai an to kaleseis apo XP Elliniko

Otan to kano response.write kai to koitao apo XP Elliniko tote
to vlepo etsi:

select * from tableName where start_date >=#01/01/2004# and start_date < #01/02/2004# order by start_date

Tin imerominia tin ftiaxno me antistoixes functions san autes pou mou esteile o Alex kai xrisimopoio ta parakato sto include arxeio:

Session.CodePage = 1253
Session.LCID = 1032


Euxaristo!

Απάντηση από:Alex

Το table στην βάση είναι date ή text;

Απάντηση από:manrj

Date/Time --> Short Date