Browse by Tags

Re: DateTime, Ticks & Query Issues

Got it. Here the syntax to make it work select ContactHelper, datetime(StartDate/10000000-62135596800,'unixepoch') as Start, datetime(EndDate/10000000-62135596800,'unixepoch') as End from appointment Thanks to Michael Black (IS) for helping me. please note ContactHelper, StartDate, EndDate...

Posted to General (Forum) by robdal on 07-13-2010
Re: DateTime, Ticks & Query Issues

hi, I'm saving datetime data asSystem. DateTime.Ticks and I'm very happy with it. The only thing I would like to have is something like SELECT datetime(1092941466, 'unixepoch'); it would be something like: SELECT TicksToDateTime(AppointmentStart) where AppointmentStart is an ipothetical...

Posted to General (Forum) by robdal on 07-12-2010

Page 1 of 1 (2 items)

System.Data.SQLite