xtremephp
Posts: 40
|
| Posted: 12/04/2004, 12:30 AM |
|
I am working on a forum and the date shows but this is all it shows
12/1/00, 12:00:00 AM
the date nor time ever change any suggestions
|
 |
 |
Damian Hupfeld
|
| Posted: 12/04/2004, 4:07 AM |
|
Something probably wrong in one of the following:
either date mismatch between project and server, or incorrectky using date
field in database, or you are incorrectly using youy date query commands.
Damian Hupfeld
http://www.nexthost.com.au/services.php
"xtremephp" <xtremephp@forum.codecharge> wrote in message
news:541b175ad47697@news.codecharge.com...
>I am working on a forum and the date shows but this is all it shows
>
> 12/1/00, 12:00:00 AM
>
> the date nor time ever change any suggestions
>
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
xtremephp
Posts: 40
|
| Posted: 12/04/2004, 9:00 AM |
|
yes i believe so here what the db generated '0000-00-00 00:00:00'
|
|
|
|
xtremephp
Posts: 40
|
| Posted: 12/04/2004, 9:35 AM |
|
I still cannot get it to work
|
|
|
|
DonB
|
| Posted: 12/04/2004, 12:35 PM |
|
That's the typical value inserted as the "default" value when you fail to
provide a value in your insert or update, and the column is specified as
"Null = No". It will format as 12/1/00 00:00:00, which is what you are
seeing.
--
DonB
http://www.gotodon.com/ccbth
"xtremephp" <xtremephp@forum.codecharge> wrote in message
news:541b1f54c18fdc@news.codecharge.com...
> I still cannot get it to work
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
xtremephp
Posts: 40
|
| Posted: 12/04/2004, 1:32 PM |
|
the default value is not null
12/01/0000 12:12 AM
|
|
|
|
xtremephp
Posts: 40
|
| Posted: 12/04/2004, 2:25 PM |
|
will pay for someone to tell me how to get time to work in code charge I created a date and time with the same sql query as I did in CCS and it works great
|
|
|
|
Damian Hupfeld
|
| Posted: 12/05/2004, 2:58 AM |
|
If you really want to PAY for the answer - pay for support - $150 for a
whole year of support - and they will help you solve this. My support just
expired but I will renew it shortly.
Then when you get the answer post it here for everyone else :)
regards
Damian Hupfeld
http://www.nexthost.com.au/services.php
"xtremephp" <xtremephp@forum.codecharge> wrote in message
news:541b239687d13c@news.codecharge.com...
> will pay for someone to tell me how to get time to work in code charge I
> created
> a date and time with the same sql query as I did in CCS and it works
> great
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
ajmartin
Posts: 11
|
| Posted: 12/07/2004, 1:12 PM |
|
I had the same problem until I noticed that there is another field you need to specify.. and that is the DBFormat option.
So, I set my date field (mine is hidden) like so.....
Data Type: Date
Format: yyyymmdd
DefaultValue: CurrentDate
DBFormat: yyyy-mm-dd
And yay!! it works.
Hope that helps you.
Regards
Adam
|
|
|
|
